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
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Comparing and inserting records

Author  Topic 

vinodhg25
Starting Member

7 Posts

Posted - 2014-01-15 : 05:17:37
Hi Friends,

I need to compare multiple data from source db and insert missed data to destination db with same table. Can any one suggest me which method that i have to use.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-15 : 06:27:47
do you mean this?
http://www.sqlis.com/sqlis/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2014-01-20 : 08:58:28
Do you need to Update rows that are different in one/many columns?

Do you need to Delete rows that are present in Destination DB but no longer present in Source DB?
Go to Top of Page
   

- Advertisement -