merge two DBs into one? 1

[password99]

I have two SQL Server DBs running. Is there a way to merge the two into one? If yes, how is concurrency handled?

 

[Joeybear23]

You can put all of the tables of one DB into the other DB.
If any objects have the same schema, you will have problems. All programs that access the tables being moved will have to be changed.

Are these both on the same server, or are they on separate servers?

 

[mrdenny]

You would have to write the scripts to merge the data and handle the concurrency by hand. I don't know of any tools that could handle this for you.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Corran007]

So do you mean you have two databases and wish to get rid of the two and go down to one? or do you mean you have two and wish to make a third thats both. or you have two and wish to put all the data from one into the other and keep both?

 

[password99]

Thanks for your time to answer the question.

I am looking to merge two database with the same data structure and tables but different data into one database.
i.e. I have two databases and wish to get rid of the two and go down to one.

 

[Corran007]

I would look into Data transformation Services(dts) import packages. if the data is different than you shouldnt have any problems. if its some of the same, its a bit tricker but still doable. Look into DTS in books online. i would start with the overview and go from there.

theres actually is a forum specifically for DTS if you have any questsions

good luck.