SQL Data Compare comparison clarification
rogabone
Posts: 2
Can someone please remind my for sanity sake;
when I compare a data row and there are left (source only) center (similar but different) and right (destination only) and there are positive values in all 3 and I do a synchronization from default left to right, what happens to the data ultimately in the destination?
when I compare a data row and there are left (source only) center (similar but different) and right (destination only) and there are positive values in all 3 and I do a synchronization from default left to right, what happens to the data ultimately in the destination?
Comments
By default if everything is selected then we will deploy all the only in left rows, update the similar ones to match the left and delete all the destination only rows.
You can change this behavior by selecting/deselecting rows and by choosing to uncheck the deletion of right only rows (for example), but by default we will deploy in such a way as to make the destination table identical to the source after deployment.
Software Developer on SQL Compare and SQL Data Compare