Is there an easy way to combine two SQL Server 2005 databases into a single database? I want to take database 'A' and database 'B' and merge them both entirely into database 'C'.
Thanks!
A:
That's called "data conversion" in the business. It can be a full project in itself, there is no quick and dirty answer for your question.
Otávio Décio
2009-02-04 19:19:04
A:
Right click the database and click export data, and then follow the wizard. Do the same for the other database.
Andrew Burgess
2009-02-04 19:20:57
+2
A:
It depends what you mean by "merge". If you have two disjoint sets of tables and want to transfer them into the same database structure, that's not a huge problem.
If you are needing to interleave or transform the data from A and/or B, they way to do it will be completely dependent on what you are trying to accomplish.
mwigdahl
2009-02-04 19:21:56
+1
A:
I'm not sure if you want to do this by yourself or are looking for a tool that will help you. If latter is an option, take a look at RedGate's SQL Compare and SQL Data Compare. These tools will let you see the differences between the schemas(SQL Compare), as well as the data in each database(SQL Data Compare). Also, they're free for 14 days and fully functional during that period.
Hope this helps,
Srdjan
Srdjan Pejic
2009-02-04 19:22:48