Baseline scripts

After generating Create database script, the tool generates Baseline migration script.

What is a Baseline?

A baseline script is a script that creates a database to exactly the same version as the selected database.

Baseline scripts are used for a couple reasons:

  • To contain database changes for existing databases
  • To "bundle" multiple migration scripts (rebasing)

The changes you make after the baseline script will be generated as migration scripts.

During database deployment, a baseline script will not be executed if the target database exists - the baseline script may fail as the target database already has objects.

Rebasing

To speed up database creation from migration scripts and reduce the number of small migration scripts to be executed, the database could be scripted out into a single Baseline script.

The migration scripts are only executed after the last Baseline script.