This tutorial uses the demo.db sample database as your consolidated database. Your SQL Anywhere installation includes a MobiLink sample database called CustDB, but it is already set up as a MobiLink consolidated database. This tutorial starts from scratch and shows you how to set up a SQL Anywhere database to use as a consolidated database.
To run the Create Synchronization Model Wizard
Start the wizard.
Sybase Central opens.
The Create Synchronization Model Wizard appears.
Type a name and location for your model.
The Primary Key Requirements page appears. This page is informational only. Select all three checkboxes and click Next.
The Consolidated Database Schema page appears. In this page, you select the database you want to use as your consolidated database. For this tutorial, you use the sample database called Demo. This sample database has not been set up for MobiLink synchronization.
The Connect window appears.
A window appears asking if you want to install System Setup. Click Yes.
System objects are installed that make the demo database able to perform MobiLink synchronization.
The Consolidated Database Schema page appears again, showing that you are connected to SQL Anywhere 11 demo. Click Next.
The Remote Database Schema page appears. Select No, Create a New Remote Database Schema and click Next.
The New Remote Database Schema page appears. Click Select All and then click Next.
The Download Type page appears. Leave the default, Timestamp-based Download. Click Next.
The Timestamp Download Options page appears. Leave the default and click Next.
The Download Deletes page appears. Leave the defaults and click Next.
The Download Subset page appears. Leave the default and click Next.
The Upload Conflict Detection page appears. Choose Row-based Conflict Detection and click Next.
The Upload Conflict Resolution page appears. Choose Consolidated Database Wins and click Next.
The Production, Script Version and Description page appears. Click Next.
The Completing The Create Synchronization Model page appears. Click Finish.
Model mode opens, showing your model with all the settings you chose in the wizard.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|