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
 General SQL Server Forums
 Database Design and Application Architecture
 Data Truncation Issue

Author  Topic 

baddulas
Starting Member

11 Posts

Posted - 2014-03-29 : 06:58:51
Hi all,

Please help on the below scenario.

Source - Oracle
Target - SQL Server

After every 2 hours data is truncating from target and loading the source data.Now i don't want to lose the target data.only matched records needs to be delete from target.

Which approach is best for the above scenario.
   

- Advertisement -