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.
This tutorial assumes that the pubs2 sample schema is installed on an Adaptive Server Enterprise 15.7 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 at http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc31654.1570/html/sag1/X21150.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 http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36272.1570/html/commands/CHDGIFDG.htm.
Lesson 1: Designing the schemas
Lesson 2: Preparing the consolidated database
Lesson 3: Adding unique keys to the consolidated database
Lesson 4: Connecting with MobiLink
Lesson 5: Creating a MobiLink project and synchronization model
Lesson 6: Modify a synchronization model
Lesson 7: Deploying the synchronization model
Lesson 8: Starting the server and client
Lesson 9: Setting the remote ID
Lesson 10: Synchronizing
Lesson 11: Viewing the data in the remote database
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|