Generating for MobiLink

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

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

1. 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.
2. Specify a directory in which to generate the scripts.
3. [optional] Select the Check Model option to verify the validity of your model before generation.
4. 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.
5. 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.

6. 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 ILM, 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.