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

SQL Anywhere 11.0.1 » 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 and choose Deploy.

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

  3. On the Consolidated Database Deployment Destination page, complete the following fields:

    1. Click Save Changes To The Following SQL File and accept the default location for the file.

      MobiLink generates a .sql file that makes changes to the consolidated database to set up for synchronization. You can examine the .sql file later and make your own changes. Then, you must run the .sql file yourself.

    2. To immediately apply the changes to the consolidated database, click Connect To The Consolidated Database To Directly Apply The Changes.

    3. Click Choose A Consolidated Database.

    4. Select ODBC Data Source Name and choose ase_cons.

    5. In the User Id field, type sa.

    6. In the Password field, type sa.

    7. Click OK.

    8. Click Next.

      A prompt appears asking if you want to create the consolidated directory. Click Yes.

  4. On the Remote Database Deployment page, click New SQL Anywhere Database. Click Next.

  5. On the New SQL Anywhere Remote Database page, complete the following fields:

    1. Click 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. In the SQL File field, accept the default location of the SQL file.

    3. Click 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. In the SQL Anywhere Database File field, accept default location of the remote SQL Anywhere database.

    5. Click Next.

      A prompt appears asking if you want to create the remote directory. Click Yes.

  6. On the MobiLink User page, complete the following fields:

    1. In the What User Name Do You Want To Use For Connecting To The MobiLink Server field, type ase_remote.

    2. In the What Password Do You Want To Use field, type ase_pass.

    3. Click Next.

  7. On the Synchronization Stream Parameters page, click TCP/IP and in the Port field, type 2439. Click Next.

  8. On the Client Stream Parameters page, in the Host field, type localhost. Click Next.

    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.

  9. To accept the default settings, click Next on the MobiLink Server Stream Parameters and Verbosity For MobiLink Server pages.

  10. On the Options For MobiLink Server page, in the What Name Do You Want To Give The MobiLink Server field, type ase_mlsrv. Click Next.

    A message appears asking if you want to create the mlsrv directory. Click Yes.

  11. Choose the verbosity for the remote synchronization client and use the default file name of the remote database log file. Click Next.

  12. Click Finish.

  13. 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