Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zath
Constraint Violating Yak Guru
298 Posts |
 Posted - 2007-02-02 : 11:11:43
|
| I have 2 sql server 2000 databases, let's call them db1 and db2.I would like to take everything from db1, including tables, data, contraints, stored procedures, etc and add them to db2.There will be no duplicate table or sp names.What is the best way to achieve this?I've been hunting around for a tutorial, but alas, no luck.Thanks,Zath |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-02 : 12:46:37
|
| Script all of your objects using the Generate SQL Script wizard. Then use bcp.exe, DTS, or T-SQL to move the data. Let us know if you have specific questions about any of this.Tara Kizer |
 |
|
|
Zath
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-02-02 : 13:18:25
|
| Yea, that's what I'm doing is generating the scripts.A lot of tables with a lot of dependencies.Have to be careful on the order!Thought there might be an easier way :DZath |
|
|
|
|
|
|
Merge Databases