Each time you use SQL Change Automation to import changes from a database it will generate a migration script. It is possible to edit these migrations to give greater control over how your changes will be deployed. To ensure that the project will be successfully deployed to other environments it is recommended that you perform a local verification of the project.

Verifying a project will:

• Check each of your migrations and programmable objects for valid SQL and alert you to any errors
• Deploy your project to the shadow database to ensure that the scripts will run successfully

Verify

To verify your project, navigate to the Verify page.

Viewing results

Once the verification has completed you can view any errors or warnings.

• Errors indicate issues with the project that must be resolved before it can be deployed
• Warnings indicate potential issues that may cause unexpected behavior.

If the issues are due to one of the files in your project you can double-click on the message to start editing the file.