COPY a system from a DB to other

[Dracula Untold]

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

[NoIdeaForAName]

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 !

[EdwardTeach+-]

or simple pay me some bucks and imma do it for you

[WickedNite.]

>calls himself a dev
>wants to copy stuff from other dbs
>can't even copy

elitepvpers in a nutshell

[D3vil Power]

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 */ 


[Spidy.]

^
#Closed