When you prepare an ASA database to be used as a remote database on a device, you usually define a subset of the enterprise database that is relevant to the needs of the mobile application. There are several options available for building an ASA database from an enterprise database:
Use Sybase Central
Use PowerDesigner
Use tools that come with your enterprise database
After you have built the ASA database, you can copy it to the device using Microsoft ActiveSync. You also need to create a DSN file and copy it to the root directory on the device. For more information, see “About ASA data sources”.
Sybase Central is a utility that allows developers to build an ASA database from another database management system. Sybase Central can be installed from the ASA installation program. For example, these are the steps needed to start with an Oracle database and build an ASA database and use it with PocketBuilder:
Open Sybase Central.
Connect to an Oracle database.
Migrate required tables to ASA.
Use MobiLink scripting capabilities to generate initial scripts.
Use the PocketBuilder Database painter to view the database schema.
Develop an application using the ASA database in PocketBuilder.
Deploy the application to the Windows CE device or emulator.
PowerDesigner Physical Architect allows you to reverse-engineer enterprise databases and create corresponding ASA databases. It also gives you the ability to manipulate the database schema. PowerDesigner Physical Architect is provided with the full version of SQL Anywhere Studio. It is not provided with PocketBuilder.
You can use the tools that come with your enterprise database to view the database schema. You can then create the ASA database in the tool of your choice, such as Sybase Central, PowerDesigner, or a command-line tool.
For information about preparing remote databases for use with MobiLink, see Chapter 17, “Using MobiLink Synchronization.”
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
