Generating for MobiLink

You can generate MobiLink scripts (*.sql) for the replication process, and/or for the consolidated and remote databases.

One SQL file is generated per server and contains all the orders for the server. The SQL file cannot be executed using a live database connection. You need to use the isql command to execute this SQL file. You can preview the script that will be generated for each object on the Preview tab of its property sheet.

Note:

In order for you to connect properly to the replication process you must verify that:

The code of the replication process object corresponds to the instance name of the MobiLink server.
The User name and Password extended attributes correspond to the MobiLink server login user name and password.
Each database has been generated using one of the Generate commands from its contextual menu.

isql.exe -e -U USRNAME -P PWD -S SVR_TEST -i SVR_TEST.sql

Select Tools > MobiLink version > Generate Scripts to open the Generation dialog.
You can, alternately, right-click any database or replication process in the synchronization environment and select Generate Scripts to open the Generation dialog and generate a script for that element only.
Specify a directory in which to generate the scripts.
[optional] Select the Check Model option to verify the validity of your model before generation.
On the Selection tab, select the objects that you want to include in the generation. Use the sub-tabs to navigate between separate lists of object types. The selections you make here will affect the files that are available to select on the Generated Files tab.

On the Options tab, set generation options as appropriate. The following options are available:

Option	Description
Drop publication/subscription before creation	Specifies to include drop statements to remove a publication and all of its articles or a subscription to a publication from the system tables before recreating it.
Delete old synchronization scripts	Specifies to delete all the previously specified synchronization scripts versions from the MobiLink system tables.

Click OK to generate the scripts in the specified directory.

When the generation is complete, the Generated Files dialog opens listing the scripts, each of which you can open and review by selecting it and clicking Edit.

The MobiLink file is generated in the destination directory.

Generating the Consolidated Database
When you specify a MobiLink synchronization definition, you usually have to modify the consolidated database to perform actions, such as update or delete shadow tables, add stored procedures, add timestamp columns, etc.
Specifying MobiLink Generation Options
The following options are available on the Options tab of the Generation dialog box:
Generating MobiLink Synchronization Scripts
You can generate the connection scripts and table scripts contained in your MobiLink server.
Registering MobiLink Users
Once the MobiLink synchronization users are specified in the remote database property sheet, you have to register them in order to let them connect to a MobiLink server.
Generating a Remote Sybase AS Anywhere Database for a Single MobiLink User
In the DMM, articles reflect the structure of the remote database. When you specify articles and article columns in the MobiLink server, you have to make sure that the remote database tables and columns have the same name as those of the definition of articles.
Generating Remote Sybase AS Anywhere Databases for All MobiLink Users
If you need to deploy the remote Sybase AS Anywhere database to multiple devices, you have to create a Sybase AS Anywhere database for each MobiLink user. This database should contain the synchronization user, the synchronization subscription, and the global database ID.
Generating a Remote UltraLite Database
If you need to generate a remote UltraLite® database, you have to create a remote Sybase AS Anywhere database first, then convert it to an UltraLite database.
Generating All MobiLink Script Files
You can generate all the MobiLink script files of your model at once.

Parent topic: Working with MobiLink