August 28, 2009 at 11:01 pm
Hi All,
Is there any way to merge all the tables with relationships from multiple Databases to single Database.
For Example: I am having 5 Db's. Each of the Db contains 10 - 15 tables.
Now I need to Create a single Db which includes all the tables from 5 Db's.
Can it be done in some other way instead of taking the Scripts and running it. Please help me out Experts...
Thanks In Advance:-)
With Regards
Vijay
August 29, 2009 at 2:49 pm
Hi
It really depends... Do you need to do this once or on a regular basis?
are there any naming conflicts between any of the objects?
The simplest way would be to create a new empty DB, and run
Select * INTO NewDB..Table1 from OldDb..Table1for each table.
Another way would be to leave your tables in different DBs and have them referenced using "Synonyms" (read more in BOL or ask here)
Could you post some more info about the case?
August 29, 2009 at 3:04 pm
vijaysingh (8/28/2009)
Is there any way to merge all the tables with relationships from multiple Databases to single Database.
The simple answer is: Yes, everything is doable.
On the other hand, this is too broad of a question with too little detail provided. I suspect there is more there than it is apparent today.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply