Lesson 7: Creating a synchronization model

In this lesson, you create a synchronization model.

Prérequis

This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating a consolidated database.

This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Using central administration of remote databases.

Contexte et remarques

If you are adding central administration to existing synchronization system, proceed to Lesson 8: Deploying the synchronization model.

Task

Define the tables for the remote database in the consolidated database. In the Folders view of Sybase Central under MobiLink 16, expand Central Admin Tutorial, Consolidated Databases. Right-click Tutorial - DBA 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 » New » Synchronization Model.
On the Welcome page, type tutorial1 for the name of the new synchronization model. Click Next.
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. Click Finish.

Résultat

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.

Suivant

Proceed to Lesson 8: Deploying the synchronization model.

Discuter à propos de cette page dans DocCommentXchange.