Options
Data compare withou sql compare
vernebe
Posts: 4 New member
Hello,
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.
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.
Comments
Thanks for your post.
Am I right i assuming you are using SQL Data Compare UI? Please correct me if I am wrong.
If it is can you navigate in SQL Data Compare UI to New/Edit Project --> Tables & Views tab ->Columns in the comparison ->remove the columns that exist only in the source from the comparison.
More about this option here: http://documentation.red-gate.com/displ ... +and+views
Does this help at all?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com