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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Merge Databases

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
Go to Top of Page

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 :D


Zath
Go to Top of Page
   

- Advertisement -