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