MobiLink Synchronization User's Guide
  Tutorial: Writing SQL Scripts Using Sybase Central

Introduction

In this tutorial, you create a consolidated database and a remote database, and write scripts to perform synchronization. You then synchronize the two databases.

Timing 

The tutorial takes about 50 minutes.

Competencies and experience 

You will require:

• An understanding of the role of synchronization scripts in the synchronization process.

• An understanding of the properties of publications and subscriptions.

Goals 

The goals for the tutorial are to gain competence and familiarity with the following tasks:

• Creating MobiLink synchronization scripts using Sybase Central.

• Troubleshooting MobiLink errors.

Key concepts 

The key concepts you will learn from this tutorial include:

• The role of the MobiLink synchronization server and client in the synchronization process.

• How to create an ODBC connection and set the properties of an ODBC connection for Adaptive Server Anywhere.

• How to create synchronization scripts to work with MobiLink.

• How to initialize a database.

Suggested background reading 

For more information about Sybase Central, see Tutorial: Managing Databases with Sybase Central.

For more information about synchronization, see Tutorial: Synchronizing Adaptive Server Anywhere Databases.

For more information about synchronization scripts, see Introduction to synchronization scripts.