SQL Alter Scripts

SchemaBank produces the proper SQL alter scripts to help keep your database server in sync with your committed schema versions.

Under the Version Manager tab, select a version and then the Forward Engineer - SQL ALTER Script action from the drop-down list.

The version chosen will be treated as the source version and you will be asked to select the target version to start the alter script generation.

As you may understand, the alter script is actually based on the diff between the two versions chosen. If ambiguity is found during the diff process, Ambiguity Resolver will show up and guide you through to resolve the ambiguity. 

The alter script generated will contain comments that help minimize accidental data loss when altering your database server from one version to another.