COPY a system from a DB to other

12/04/2016 20:00 Dracula Untold#1
hello ..
i have on a database a nice system with chest and key .

how can i copy this system to other SHARD?

i understand that i have to copy the tables and the procedures rite? or the is something else ?


but i cannot find all the procedures .... :(
or im blind
12/04/2016 21:01 NoIdeaForAName#2
Here's my opinion (in engleza, ca nu-i voie in romana, eh).

First of all you have your procedure.

First scenario : you created it.
In this case simply create it again, using the resources you need.

Second scenario : the database you have already has it.
Learn more about SQL, search about the procedure and track it down, use google and everything you need to have a clue where things are.Don't forget to use queries in your own advantage.

And the third scenario
: backup the database and restore it to a new one created by you.

I think my advice is silly but hey, I'm trying to help.

Don't forget the AddTimedJob procedure and AddLogItem !
12/04/2016 22:17 EdwardTeach+-#3
or simple pay me some bucks and imma do it for you :D
12/04/2016 23:10 WickedNite.#4
>calls himself a dev
>wants to copy stuff from other dbs
>can't even copy

elitepvpers in a nutshell
12/05/2016 15:34 D3vil Power#5
query for Insert Table From DB to another DB

PHP Code:
USE [SRO_VT_SHARD/* Your Database Name */
GO()
TRUNCATE TABLE [dbo].[_RefObjItem/* Your Table Name */
GO()
insert into SRO_VT_SHARD.dbo._RefObjItem select from SRO_VT_SHARD1.dbo._RefObjItem /* Your Databse Name - Table Name - Other Database */ 
12/07/2016 02:31 Spidy.#6
^
#Closed