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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • suren1503
    New Member
    • Aug 2008
    • 1
    #1

    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.

    Thanks,
    Suren...
    Last edited by suren1503; Aug 21 '08, 12:12 PM. Reason: Added more descriptive Title
    Tags: None
    • Delerna
      Recognized Expert Top Contributor
      • Jan 2008
      • 1134
      #2
      Similar to another thread

      see if this helps

        Comment

        • rsrinivasan
          New Member
          • Mar 2007
          • 221
          #3
          Use tableDiff utility of SQL SERVER 2005 that will sync only updated and inserted table.

            Comment

            Previous template Next
            Working...