Managing MobiLink synchronization on the server

You can start the MobiLink synchronization server and SQL Central (formerly known as Sybase Central) from the PowerBuilder UI.

Starting the MobiLink synchronization server

Before you synchronize remote databases with the consolidated database, you must start the MobiLink synchronization server. You can start the server from the Database or the Database Profile painter in PowerBuilder.

To start the MobiLink synchronization server

  1. From the Objects view of the Database painter or from the Database Profile painter, expand the ODBC Utilities folder and click MobiLink Synchronization server.

    The MobiLink Synchronization Server Options dialog box displays.

  2. Select the MobiLink version and enter the ODBC connection string for your consolidated database.

    The values that populate the MobiLink version drop-down list come from the SQL Anywhere versions listed in the hkey_local_machine\software\odbc\odbcinst.ini registry key.

    The ODBC connection string should not contain any blank spaces that are not part of the data source name. The following is an example of an ODBC connection string for the SQL Anywhere demonstration database:

    DSN=SQL Anywhere 11 Demo;UID=dba;PWD=SQL
  3. Define other options as needed.

    For information about filling in specific fields in the dialog box, click the Help button in the dialog box. The Usage button opens a dialog box with information about command line options.

  4. Click OK.

    When you click OK, PowerBuilder starts the MobiLink Synchronization server.

Using SQL Central

You can use SQL Central (formerly known as Sybase Central) to manage MobiLink synchronization and create synchronization scripts that are held in the consolidated database. You can also use the SQL Anywhere plug-in to SQL Central to add publications, synchronization users, and synchronization subscriptions to remote databases.

To start SQL Central

  • From the Objects view of the Database painter or from the Database Profile painter, expand the ODBC Utilities folder, and click SQL Central.

    SQL Central displays.

To work with the consolidated database in SQL Central

  • Select Connections>Connect with MobiLink 11 from the SQL Central menu, enter connection parameters in the Connect to Consolidated Database dialog box, and click OK.

    You can use SQL Central to add scripts for database tables and select synchronization events that cause the script to be executed.

To work with remote databases in SQL Central

  • Select Connections>Connect with SQL Anywhere 11 from the SQL Central menu, enter connection parameters in the Connect dialog box, and click OK.

    If you open the Publications and MobiLink Users folders in SQL Central, you can add publications and synchronization users for the remote database.

    After you add a publication and a synchronization user, you can create a synchronization subscription by linking a publication to a synchronization user.

    For more information, see Using MobiLink Synchronization in Application Techniques and the SQL Anywhere online Help. You can also use the Help menu for the SQL Anywhere and MobiLink plug-ins to SQL Central.