Adding and deleting scripts

When you use the Create Synchronization Model Wizard, scripts are automatically added to the consolidated database when you deploy the model.

When you create synchronization scripts outside Sybase Central, you must add them to MobiLink system tables in the consolidated database. For SQL scripts, the entire script is saved in the MobiLink system table. For Java or .NET scripts, the method name is registered in the system table. The method for storing scripts and method names is similar.

See MobiLink server system tables.

If you are using Sybase Central, you must add a script version to the database before you can add individual scripts. See Adding a script version.

Add a connection script (Sybase Central)

From the View menu, click Folders.
In the left pane of Sybase 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.
Right-click Connection Scripts and click New » Connection Script.
Follow the instructions in the Create Connection Script Wizard.

Delete a connection script (Sybase Central)

From the View menu, click Folders.
In the left pane of Sybase 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.
Expand Connection Scripts.
Right-click a connection script and click Delete.
Click Yes.

Add a table script (Sybase Central)

From the View menu, click Folders.
In the left pane of Sybase 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.
Expand Synchronized Tables.
Right-click the table and click New » Table Script.
Follow the instructions in the Create Table Script Wizard.

Delete a table script (Sybase Central)

From the View menu, click Folders.
In the left pane of Sybase 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.
Expand Synchronized Tables.
Expand the table.
Right-click the table script and click Delete.
Click Yes.

Add or delete all types of scripts (system procedures)

You can add scripts to a consolidated database or delete scripts from a consolidated database using stored procedures that are installed when you set up your consolidated database.

For information about the stored procedures that you can use to add or delete scripts, see:

Direct inserts of scripts
Ignored scripts

Discuss this page in DocCommentXchange.