Data Merge
fjameel
Posts: 2
Hi,
We maintain an extensive list of contacts in a SQL server database. Every so often we get additional contact info that needs to go in this database. Some of the contacts in this list are already in our database and just need to be updated, while others are new and would need to create new rows. Is there a way SQL data compare can handle this merge/ insert ?
Thanks
We maintain an extensive list of contacts in a SQL server database. Every so often we get additional contact info that needs to go in this database. Some of the contacts in this list are already in our database and just need to be updated, while others are new and would need to create new rows. Is there a way SQL data compare can handle this merge/ insert ?
Thanks
Comments
The simple answer is yes, but it gets more complicated depending on the databases concerned. If the comparison key (primary key) matches between both databases, then the record is updated. If it doesn't exist in the destination database, then it is inserted. If the identity values of the primary key do not match between the two databases, you may have a problem because potentially records can be updated with the wrong record's data.
Data Compare can only 'push' changes to the destination database, so a two-way data synchronization would be extremely complictaed in any case.
We can send a best practices document for Data Compare if you write support@red-gate.com and ask for it (it's not on the website yet!).