MobiLink Synchronization User's Guide
Writing Synchronization Scripts
Adding and deleting scripts in your consolidated database
You can add synchronization scripts using Sybase Central wizards. The procedure is different for connection scripts and table scripts. Table scripts correspond to tables in the remote database, so before you can add a table script, you must add the name of the remote database table to the consolidated database.
If you are using Sybase Central, you must add a synchronization version to the database before you can add individual scripts. For more information, see Adding a script version.
To add or delete a connection script (Sybase Central)
From Sybase Central, right-click MobiLink Synchronization and connect to the consolidated database.
Open Connection Scripts.
To add a connection script, double-click Add Connection Script and follow the instructions in the wizard.
or
To delete a connection script, right-click the script name and select Delete. The Confirm Delete dialog appears. Click Yes.
To add or delete a remote table in the list of synchronized tables (Sybase Central)
From Sybase Central, right-click MobiLink Synchronization and connect to the consolidated database.
Open Synchronized Tables.
To add a remote table to the list of synchronized tables, double-click Add Synchronized Table. Enter the name of a table at the remote database for which you are going to write synchronization scripts. The wizard provides a shortcut if the consolidated database has a table with a matching name.
or
To delete a remote table from the list of synchronized tables, right-click the table name and select Delete. The Confirm Delete dialog appears. Click Yes.
To add or delete a table script in a database (Sybase Central)
From Sybase Central, right-click MobiLink Synchronization and connect to the consolidated database.
Open Synchronized Tables.
Select the table for which you wish to add a script.
To add a table script, double-click Add Table Script and follow the instructions in the wizard.
or
To delete a table script, right-click the script name and select Delete. The Confirm Delete dialog appears. Click Yes.
To add or delete all types of scripts (stored procedures)
You can add scripts to a consolidated database or delete scripts from a consolidated database using stored procedures that are installed along with the MobiLink system tables when you create your consolidated database.
For a description of the stored procedures that you can use to add or delete scripts, see Stored procedures to add or delete scripts.