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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Java Programming » Tutorial: Building a BlackBerry application » Part 2: Using MobiLink to synchronize the BlackBerry application


Lesson 2: Setting up a MobiLink server and deploying a synchronization model

In this lesson, you use Sybase Central to prepare your consolidated database for synchronization.


This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up your MobiLink consolidated database.

  1. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  2. Click Tools » MobiLink 16 » New Project.

    The Create Project Wizard appears.

  3. In the Name field, type rim_project.

  4. In the Location field, type C:\HelloBlackBerry\database, and then click Next.

  5. In the Database Display Name field, type HelloBlackBerry.

  6. Click Edit.

  7. Perform the following tasks on the Connect To A Generic ODBC Database page:

    1. In the User ID field, type DBA.

    2. In the Password field, type sql.

    3. In the ODBC Data Source Name field, click Browse and select HelloBlackBerry.

    4. Click OK, and then click Save.

  8. Select the Remember The Password option, and then click Next.

  9. Ensure that only the Names table is selected from the Which Consolidated Database Tables And Columns Do You Want To Have In Your Remote Database list, and then click Next on all remaining dialogs to end of the wizard.

    A synchronization model has been created.

  10. Right-click your new Synchronization model,and select Properties.

  11. In the first text field, type HelloBlackBerrySyncModel, click Apply, and then click Ok.

  12. In the left pane of Sybase Central under MobiLink 16, expand rim_project, Synchronization Models and then HelloBlackBerrySyncModel.

  13. Click File » Deploy.

  14. Under the Specify The Deployment Details For One Or More Of The Following option, ensure that only the Consolidated Database option is selected. Click Next.

  15. Perform the following tasks on the Consolidated Database Deployment Destination page:

    1. Select 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 manually.

    2. Immediately apply the changes to the consolidated database.

      Select Connect To The Consolidated Database To Directly Apply The Changes.

    3. Select the HelloBlackBerry consolidated database from the list.

    4. Click Next.

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

  16. On the MobiLink User and Synchronization Profile page, type mluser for the user name and mlpassword for the password, and then click Finish.


A MobiLink project is created and the synchronization model for the consolidated database can now be deployed.