472,125 Members | 1,393 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

DTS: Copy new + modified records from table1 to table2 from two different servers

Hi All Techies,

I have created one DTS to copy table1 (which is on Oracle server) to table2 (on SQL Server 2000)
I want to copy only new records + modified records from table1 to table2.

I would appreciate the help.

Aug 21 '08 #1
2 1566
1,134 Expert 1GB
Similar to another thread

see if this helps
Aug 21 '08 #2
221 100+
Use tableDiff utility of SQL SERVER 2005 that will sync only updated and inserted table.
Aug 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Peter CCH | last post: by
1 post views Thread by Sean Howard | last post: by
3 posts views Thread by colleen1980 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.