Comments
3 comments
-
Thanks for your post!
I have logged a support ticket for you and will email you shortly! -
Hey! I have the same issue and couldn't find the solution for it.
-
Hi ckaeser ,
At present you can achieve this by going into comparison results and for each table selecting the columns manually.
If you wish to have this automated, can you please kindly leave a suggestion on our user voice forum so that other people can vote for it.
Add comment
Please sign in to leave a comment.
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?
Example:
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