Inserting bulk data into a table it's easy, but... having two tables that need to be synchronized is that an straight forward task
This article explains how to copy all the rows from an origin table to a destination one, taking into consideration that somes rows doesn't exists (insert / create) and some other yes (update)
you will find two SQL script solutions and two based on SSIS
|