Introduction to Adaptive Server Enterprise tutorial

This tutorial shows you how to mobilize an Adaptive Server Enterprise database using MobiLink. It sets up synchronization between an Adaptive Server Enterprise consolidated database and a SQL Anywhere remote database. You could also use UltraLite clients.

The purpose of this tutorial is to mobilize data for a chain of bookstores. Each bookstore in this scenario is a remote synchronization environment. Each bookstore has a local SQL Anywhere database that is synchronized with the Adaptive Server Enterprise database at headquarters. Each bookstore can have several computers that access and manipulate data from the remote database.

Required software

This tutorial assumes you have a complete install of SQL Anywhere (including MobiLink) on your local computer where you are running the tutorial. This tutorial was created using Adaptive Server Enterprise 15.0. The tutorial may work for other versions of Adaptive Server Enterprise, but this is not guaranteed. This tutorial also assumes you have installed Adaptive Server Enterprise 15.0 on your local computer. You may also access Adaptive Server Enterprise 15.0 remotely using Sybase Open Client.

This tutorial assumes that the pubs2 sample schema is installed on an Adaptive Server Enterprise server. The pubs2 sample schema is provided with Adaptive Server Enterprise 15.0 and it is an optional part of the install. For this tutorial, it is used as the consolidated database. Information about this sample can be found in the Adaptive Server Enterprise documentation or can be viewed online at [external link] http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug894.htm.

This tutorial uses the default sa account. When Adaptive Server Enterprise is installed, the sa account has a null password. This tutorial assumes you have changed the null password to a valid password. For more information about changing the null password in Adaptive Server Enterprise, see [external link] http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sag1/html/sag1/sag1615.htm.

Overview

This tutorial shows you how to:

  • Make important considerations, such as synchronization directions for remote tables, when designing a remote schema.
  • Add unique primary keys to consolidated and remote databases.
  • Create an ODBC data source that connects MobiLink to an Adaptive Server Enterprise database.
  • Set up synchronization between a consolidated database and remote database using the Create Synchronization Model Wizard.
  • Customize a synchronization model using Model mode.
  • Deploy a consolidated database and remote database using the Deploy Synchronization Model Wizard.
  • Synchronize the remote client with the consolidated database.
Suggested background reading

For an overview of MobiLink synchronization, see Introducing MobiLink synchronization.