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 Oracle 10g consolidated database


Lesson 5: Deploy the synchronization model

This procedure uses the Deploy Synchronization Model Wizard to deploy the consolidated database and remote database. You can deploy the consolidated database and remote database individually or both of them.

To deploy the synchronization model
  1. In the left pane of Sybase Central, right-click a synchronization model and choose Deploy.

  2. On the Welcome page, 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, do the following:

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

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

    3. Click Choose A Consolidated Database.

    4. Click ODBC Data Source Name and choose oracle_cons.

    5. Click OK.

    6. Click Next.

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

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

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

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

    2. In the SQL File field, accept the default location of the SQL file.

    3. Click Create A Remote SQL Anywhere Database.

    4. Click Next.

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

  6. On the MobiLink User page, do the following:

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

    2. In the What Password Do You Want To Use field, type oracle_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.

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

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

  11. On the Verbosity For SQL Anywhere Remote Synchronization Client page, choose the verbosity for the remote synchronization client and use the default file name of the remote database log file. Click Finish.

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