RE: To merge several tables into one

SSC Guru

Points: 183698

June 5, 2013 at 12:50 pm

DiverKas (6/5/2013)
Assuming you have down time, my suggestion would be:
Merge all your tables into one table with no constraint, with an additional column indicating the source database/table it came from. Add a new IDENTITY column (OR UNIQUEIDENTIFIER if your going that route). Then you can simply update your ancillary tables with the new ID, joined on the old ID. Then drop the source column and old ID and its done.
This isnt that hard, and you would need downtime to accomplish it.

Is not that hard for a single table, but as far as I understand, the idea is to migrate all tables from multiple databases.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2