Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » MobiLink - Getting Started » MobiLink Tutorials » Tutorial: Using MobiLink with an Adaptive Server Enterprise consolidated database

 

Lesson 5: Deploy the synchronization model

The Deploy Synchronization Model Wizard allows you to deploy the consolidated database and remote database. You can deploy each of these individually or you can deploy both of them. The Deploy Synchronization Model Wizard takes you through the steps of configuring options for deployment.

To deploy the synchronization model

  1. In the left pane of Sybase Central, right-click the synchronization model you just created and choose Deploy from the popup menu.

    The Deploy Synchronization Model Wizard appears.

  2. Choose deployment settings:

    1. Select Specify The Deployment Details For One Or More Of The Following.
    2. Select Consolidated Database, Remote Database And Synchronization Client, and MobiLink Server.

      This instructs MobiLink to deploy each piece of the synchronization environment.

  3. On the Consolidated Database Deployment Destination page, configure the options for deploying the consolidated database:

    1. Select Save Changes To The Following SQL File. For this tutorial, use the default location.

      MobiLink generates a .sql file that makes changes to the consolidated database to set up for synchronization.

    2. You may select Connect To The Consolidated Database To Directly Apply The Changes. This option causes MobiLink to apply the changes immediately to the consolidated database.

      You may also examine the .sql file later and make your own changes. Then, you must run the .sql file yourself.

  4. On the same page, connect to the consolidated database:

    1. Click Choose A Consolidated Database.

      The Connect To Consolidated Database window appears.

    2. Select ODBC Data Source Name and choose ase_cons.
    3. Type sa as the User Id and the Password for the sa account. Click OK.

      The Checking For MobiLink System Setup window appears. Once the tables from the consolidated database have loaded, the name, user, product and version appear on the page.

    4. Click Next.

      A window appears and it asks if you want create the consolidated directory. Click Yes.

  5. On the Remote Database Deployment page, specify the type of remote database being deployed. Select New SQL Anywhere Database.

  6. On the New SQL Anywhere Remote Database page, configure the options for creating a new remote database:

    1. Select Make A Command File And A SQL File With Commands To Create The Database.

      MobiLink generates another .sql file with the commands to set up the remote database with all schema and synchronization information.

    2. Use the default location of the SQL file.
    3. Select Create A Remote SQL Anywhere Database.

      If you choose not to do this, you must generate a new remote database, and then run the .sql file against it. This allows you to examine the .sql file later and make your own changes.

    4. Use the default location of the remote SQL Anywhere database.
    5. Click Next.

      A window appears and it asks if you want to create the remote directory. Click Yes.

  7. Configure the options for deploying the MobiLink server:

    1. On the MobiLink User page, type ase_remote as the MobiLink user name and type ase_pass as the password.

      The MobiLink user is stored in a MobiLink system table and is used to authenticate the user during synchronization.

    2. On the Synchronization Stream Parameters page, choose TCP/IP as the communication protocol and enter 2439 as the port to use.
    3. On the Client Stream Parameters page, type localhost as the host name of the MobiLink server computer.

      You can optionally type your computer's name or IP address, the name or IP address of another network server you want to use, or other client stream options.

    4. On the MobiLink Server Stream Parameters page, you can specify additional server stream options.
    5. On the Verbosity For MobiLink Server page, choose the amount of log verbosity and use the default file name for the log file.

      You can use the log file for troubleshooting if you encounter any errors.

    6. On the Options For MobiLink Server page, type ase_mlsrv as the name of the MobiLink server and use the default location of the command file.

      You use the command file to start the MobiLink server.

    7. Click Next.

      A window appears and it asks if you want to create the mlsrv directory. Click Yes.

  8. Configure the options for deploying the remote synchronization client:

    1. On the Verbosity For SQL Anywhere Remote Synchronization Client page, choose the verbosity.
    2. On the same page, use the default file name of the remote database log file.
    3. On the Advanced Options For SQL Anywhere Remote Synchronization Client page, you can specify advanced options.
    4. On the same page, use the default location of the command file and click Next.

      MobiLink generates a command file that you can use to start synchronization.

  9. Click Finish.

    A Completing The Deploy Wizard window appears. Click Finish.

  10. A Deploying window appears. When the deployment completes, it shows Status: Completed. Click Close.

Your consolidated database is fully configured for synchronization with many remote clients, and you have successfully deployed one remote client. If you want to deploy other remote clients, you can run this wizard again, making sure to create a new MobiLink user and opt out of deploying the consolidated database and MobiLink server. Since these have already been deployed, all you need to do is deploy other remote synchronization clients.

Further reading