High level of customization

Last modified: July 7, 2023

Schema Compare for SQL Server offers a wide range of synchronization options, providing users with the flexibility to customize the process according to their specific and demanding requirements. Whether it involves fine-tuning the execution of transactions, configuring specific deployment behaviors, or customizing synchronization output, Schema Compare enables users to achieve a highly customized and optimized synchronization experience.

The tool allows you to configure not only the synchronization options but also the comparison settings, ensuring an optimal experience tailored to your preferences.

With Schema Compare, you can:

• Easily configure the comparison and sync options: Schema Compare offers user-friendly wizards that guide you through the process of customizing the comparison and synchronization options. This intuitive interface simplifies the configuration, making it easy for users to define their desired settings.

• Map schemas explicitly: Schema Compare allows users to manually define mappings between schemas during the comparison. This offers a more granular level of control and flexibility in managing the process.

• Map tables and columns: Schema Compare allows for manual mapping of tables and columns with different names. This helps prevent data loss when deploying tables or columns that have been renamed for some reason.

• Filter objects for sync: With Schema Compare, you can take control of your schema management by selectively filtering objects to be synced, ensuring a flexible, focused, and efficient synchronization experience adjusted to your project’s needs.

• Control the synchronization output: Schema Compare empowers you to conveniently manage schema synchronization results - just choose from a range of convenient actions such as opening the synchronization script in our user-friendly internal editor, securely saving the script to a file for future reference, or executing the script directly against the target database for immediate impact.

• View dependent objects: With Schema Compare, you have the ability to explore and understand the dependencies in your schema. In case any dependent objects were missed during the initial setup, you can easily include them in the synchronization process. This ensures a comprehensive and accurate synchronization, leaving no important elements behind.

• Integrate custom scripts into the schema sync workflow: With the ability to incorporate custom scripts, Schema Compare empowers you to take full control of your synchronization process and unleash the full potential of your database management capabilities.