The specifics of synchronization scripts

Last modified: March 12, 2024

The following information may help you understand the behavior of synchronization scripts.

Column order

Column order option is selected by default. It means that adding a column to a table will cause its re-build. As a result, the column order will be preserved during the deployment of schema changes. If you want to ignore the difference in column ordering, clear this option when configuring a New Schema Comparison project.

Users

With Schema Compare, you can compare and deploy changes to users, such as changes in permissions. However, Schema Compare does not compare or synchronize modifications to user passwords.