Merge vs. Synchronize database

Compares and synchronizes SQL database content.

Merge vs. Synchronize database

Postby romrom72 » Mon Jun 16, 2014 9:28 pm

I recently downloaded a trial of "SQL Data Compare" hoping it would merge two databases having the same schema.
However it seems to me that the deployment is merely copying rows from tables found in source DB that are absent in destination DB tables, modifying the destination tables (via UPDATE statements) to make them identical to the source tables and deleting all rows found in the destination tables that are absent in source tables.
What I really want is a full merge of all relevant tables in both databases and for the foreign keys to be adjusted accordingly. This is how I understand a true merge and I thought that was the function of the synchronization feature. Am I asking for too much?


Source DB:

PK Rank Description
1 Private
2 Corporal
3 Sergeant

ID Name Rank
54 Joe 1
60 Frank 1
63 Robert 3

Destination DB:

PK Rank Description
3 Private
4 Corporal
5 Sargaent
7 Lieutenant

ID Name Rank
45 Steve 3
67 Max 3
78 Tom 5
80 Peter 7

Merged (Target) DB:

PK Rank Description
1 Private
2 Corporal
3 Sergeant
4 Lieutenant

ID Name Rank
1 Joe 1
2 Frank 1
3 Robert 3
4 Steve 1
5 Max 1
6 Tom 3
7 Peter 4
Posts: 1
Joined: Mon Jun 16, 2014 7:21 pm

Postby Anu Deshpande » Tue Jun 17, 2014 9:01 am

Thanks for your post!

I have logged a support ticket for you and will email you shortly!
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest