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 |
|
shyamprasad76
Starting Member
38 Posts |
 Posted - 2001-12-18 : 16:15:34
|
| Hi,I have two exactly same databases in two different SQL servers. There is table called 'Clients' in both the databases. The 'clients' table in database-A continiously gets new records. I want to append just the new rows into the 'clients' table in the database-B using DTS.I did not find an option to just append new rows from table clients in Database-A to database-B.Please help me.thanks,Shyam. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2001-12-18 : 17:14:21
|
| HiTo do this properly I think you should look into SQL Server's replication features.You could build your own way to handle this, but using the built in features will take the pain out for you.Damian |
 |
|
|
|
|
|
Question on DTS