In this lesson, you create a synchronization model. If you are adding central administration to existing synchronization system you can skip this lesson.
You first need to define the tables for the remote database in the consolidated database. In the Folders view of Sybase Central under Central Admin Tutorial » Consolidated Databases » , right-click Tutorial and choose 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 choose 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 checked 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 will 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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|