In this lesson, you use Sybase Central to prepare your consolidated database for synchronization.
Click Start » Programs » SQL Anywhere 12 » Administration Tools » Sybase Central.
Click Tools » MobiLink 12 » New Project.
The Create Project Wizard appears.
In the Name field, type rim_project.
In the Location field, type C:\HelloBlackBerry\database, and then click Next.
Select the Add A Consolidated Database To The Project option.
In the Database Display Name field, type HelloBlackBerry.
Perform the following tasks on the Connect To A Generic ODBC Database page:
In the User ID field, type DBA.
In the Password field, type sql.
In the ODBC Data Source Name field, click Browse and select HelloBlackBerry.
Click OK, and then click Save.
Select the Remember The Password option, and then click Next.
Select Create A New Model, and then click Finish.
The Create Synchronization Model Wizard appears.
In the What Do You Want To Name The New Synchronization Model field, type HelloBlackBerrySyncModel and then click Next.
Select the HelloBlackBerry consolidated database from the list, and then click Next.
Click No, Create A New Remote Database Schema, and then click Next.
On the New Remote Database Schema page, 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.
Click Timestamp-based Download, and then click Finish.
Timestamp-based downloads minimize the amount of data that is transferred because only data that has been updated since the last download is transmitted.
In the left pane of Sybase Central under MobiLink 12, expand rim_project, Synchronization Models and then HelloBlackBerrySyncModel.
Click File » Deploy.
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.
Perform the following tasks on the Consolidated Database Deployment Destination page:
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 yourself.
Immediately apply the changes to the consolidated database.
Select Connect To The Consolidated Database To Directly Apply The Changes.
Select the HelloBlackBerry consolidated database from the list.
A prompt appears asking if you want to create the consolidated directory. Click Yes.
On the MobiLink User and Synchronization Profile page, type mluser for the user name and mlpassword for the password, and then click Finish.
The synchronization model to the consolidated database can now be deployed.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|