How to Synchronize only one column.

thirith

Hi all,

When I compare between 2 DB and some column in a table are difference. I want to create the synchronization script only for one column not all of the difference columns in the same table.

How to generate the synchronization script in SQL Compare 8.0 for alter only 1 column?

Thanks,
Thirith.

David Atkinson

Unfortunately it's not possible to synchronize one column at a time as SQL Compare works at the table scope. The workaround is to generate the script and amend it manually.

I've noted your request and we'll consider this in a future release.

Kind regards,

David Atkinson
Product Manager
Red Gate Software