Data compare withou sql compare

vernebevernebe Posts: 4 New member
edited August 28, 2015 7:25AM in SQL Data Compare 11

if we do not want to sync the database with the lates information of the table structure we still would like to sync the contents.
At the moment that is not possible if the source table contains additional columns compare to the target table.

I would suggest that the sql generator would not look to the source table, but only generate a script for the columns that are available in the source and target table.

At the moment data compare generates a script with columns that are not available in de target table, so the script will fail.

Can you fix that, or create a setting to allow ignore missing columns in the target table.


Sign In or Register to comment.