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

SQL Anywhere 12.0.1 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Using central administration of remote databases


Lesson 9: Deploying the synchronization model

This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating a consolidated database.

In this lesson, you deploy the synchronization model you created in the previous lesson.

 Deploy the synchronization model
  1. In the Folders view of Sybase Central under MobiLink 12, expand Central Admin Tutorial » Synchronization Models. Right-click tutorial1 and click Deploy.

    The Deploy Synchronization Model Wizard appears.

  2. On the Welcome page, select Specify The Deployment Details For One Or More Of The Following and check the Consolidated Database, Remote Database And Synchronization Client and Initialize With Settings For Central Administration Of Remote Databases options and click Next.

  3. On the Consolidated Database Deployment Destination page, clear Save Changes To The Following SQL File and check Connect To The Consolidated Database To Directly Apply The Changes. Choose the Tutorial database and click Next.

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

  5. On the New SQL Anywhere Remote Database page, check Make A Command File And A SQL File With Commands To Create The Database and type c:\cadmin_demo\remote_db\tutorial_v1.sql in the SQL File field. Clear Create A Remote SQL Anywhere database. Click Next to continue and Yes to confirm that you want the new directory and file to be created.

  6. On the MobiLink User And Synchronization Profile page, accept the defaults.

    The {ml_username} and {ml_password} macro values are used in the generated SQL files and are replaced with the MobiLink user and password being used by the MobiLink Agent when the SQL is executed on the remote device. A synchronization profile is automatically created with the name tutorial1_{ml_username}, where the {ml_username} macro is replaced with the name of the MobiLink user, which in this case is JOHN.

  7. Clear Register This User In The Consolidated Database For MobiLink Authentication. and click Next.

  8. On the Synchronization Stream Parameters page, choose TCP/IP and enter 2439 for the Port. These are the stream parameters that you used when you started the MobiLink server earlier. Click Next until you get to the Advanced Options For SQL Anywhere Remote Synchronization Client page and then click Finish and then Yes to create the directory.

    When you navigate away from the synchronization model, you are asked if you want to save your changes. Click Yes.

  9. Proceed to Lesson 10: Creating a remote task.

You have now completed creating and deploying a synchronization model. When you deployed the model, scripts were added to the consolidated database to allow a remote database to synchronize. You also generated a SQL file in the cadmin_demo\remote_db directory, which can be used to create a remote database. You may like to look at those files now.