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)
 Copy objects from one database to another

Author  Topic 

mayoorsubbu
Yak Posting Veteran

95 Posts

Posted - 2014-01-23 : 09:38:21
Hi All,

I have two database xyz and abc in the same instance of SQL Server 2000 on the same server.

The only difference is that the target database (xyz) has a few objects (tables, indexes, sps, view, logins) more than the other that is database abc.

When I use DTS and schedule to copy all objects from abc to xyz the operation deletes the additional tables and objects from xyz.

What could be the cause. Can I acheive it programmatically. If so how?

Mar
Starting Member

47 Posts

Posted - 2014-01-28 : 08:58:32
You can compare the system tables to find what objects don't exist then copy them to another database only to copy back when you're done.
Alternately you can create a staging database.
Go to Top of Page
   

- Advertisement -