SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Merge Databases
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Zath
Constraint Violating Yak Guru

USA
284 Posts

Posted - 02/02/2007 :  11:11:43  Show Profile  Visit Zath's Homepage  Reply with Quote
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

USA
36845 Posts

Posted - 02/02/2007 :  12:46:37  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
284 Posts

Posted - 02/02/2007 :  13:18:25  Show Profile  Visit Zath's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000