Adding a script version to a consolidated database

A script version identifies a set of scripts. When working in SQL Central, you must add a script version name to your consolidated database before you can add any connection scripts.

Context

When adding scripts with system procedures, if you specify a new script version name it is automatically added with the script.

In SQL Central, only one script version is allowed per synchronization model and it is by default given the same name as the synchronization model.

To perform schema changes without synchronizing, you must add a script version to the synchronization subscription using SQL syntax.

You can add a script version in the same operation as adding a connection script or table script using system procedures.

Procedure

From the View menu, click Folders.
In the left pane of SQL Central, expand your MobiLink project name, then expand the consolidated database you want to work with.
You are connected to the consolidated database based on the connection information that was provided when you added the consolidated database to your project.
Click the Versions folder and click File New Version .
Follow the instructions in the Create Script Version Wizard.

Results

The script version is created.