This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating a consolidated database.
In this lesson, you create a synchronization model. If you are adding central administration to existing synchronization system, proceed to Lesson 9: Deploying the synchronization model.
Define the tables for the remote database in the consolidated database. In the Folders view of Sybase Central under MobiLink 12, expand Central Admin Tutorial, Consolidated Databases. Right-click Tutorial and click Open Interactive SQL.
In the SQL Statements pane type the following:
CREATE TABLE customer( cust_id INTEGER PRIMARY KEY, f_name VARCHAR(100), l_name VARCHAR(100) )
Press F5 to execute the SQL. Close Interactive SQL. You do not need to save your SQL statements.
In the Folders view of Sybase Central, right-click Central Admin Tutorial and click New » Synchronization Model.
On the Welcome page, type tutorial1 for the name of the new synchronization model.
On the Primary Key Requirements page check all three checkboxes to confirm that your schema meets the requirements for synchronization. Click Next.
On the Consolidated Database Schema page, choose the Tutorial database and click Next.
On the Remote Database Schema page, select No, Create A New Remote Database Schema and click Next.
On the New Remote Database Schema page, ensure the customer table is selected and click Next.
On the Download Type page, choose Snapshot Download and click Next.
On the Download Deletes page, answer No to the question Do You Want Data Deleted On The Consolidated Database To Be Deleted On The Remote Databases and click Next.
On the Download Subset page, check Yes, Download The Same Data To Each Remote and click Next.
On the Upload Conflict Detection page, select No Conflict Detection and click Next.
Accept the defaults on the Publication, Script Version And Description page and click Finish.
You have now created a synchronization model that contains a single table called customer that can be synchronized between the remote and the consolidated databases. The next step is to deploy that model to create synchronization objects in the consolidated database and to generate SQL for creating a remote database.
Proceed to Lesson 9: Deploying the synchronization model.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|