Use Sybase® Central from the SAP Mobile Platform installation to connect to and examine the device's database file.
The UltraLite database udb file is compatible across
device platforms.
Keep the following in mind when examining the database schema and data size:
- Query/SUPQuery operates at the database level. The MBO attribute is simply
translated into a corresponding table column if different.
- Tuning requires knowledge of the database schema generated by the Object API to
back the MBOs. The best way to examine the schema is to make a copy of the
UltraLite database after initial synchronization finishes to make sure it contains
the data set that the query operates upon.
- Query performance depends greatly on the data set. Mock data without the
characteristics of the operational data is not useful for tuning.
- Initial synchronization may require the developer to define various
synchronization parameters to download the operational data.
- You can use an actual device or a simulator to create and populate the
database.
- Make a copy of the UltraLite database file.
The databaseName.udb file location depends
on the device platform or simulator. It is generally found in the application’s data
folder.
- Launch Sybase Central (scjview.exe) to manage SQL Anywhere and
Ultralite databases.
The default installation location of the Sybase Central executable is
SMP_HOME\Servers\SQLAnywhere12\BIN32\scjview.exe.
- From Sybase Central, select View and edit the schema of a
database.
- Provide the connection information to the UltraLite database file copied
earlier.
Generally, you need not specify either a user ID or password, since the Object API
does not set them. However, if the database is encrypted, you must supply the
encryption key to open the database.
- Click Connect to connect to the copied database file.