This dialog lets you generate a set of table definitions and synchronization scripts that define an Adaptive Server Anywhere consolidated database. The synchronization scripts are determined by the settings in the MobiLink Synchronization property sheet for each table and the default settings.
The settings you make here may depend on whether this is the first time you have generated a database and scripts or whether you are modifying an existing consolidated database.
This dialog has the following components:
Settings General settings defining global settings for the generation.
MobiLink script version The synchronization scripts are defined for a script version. Your UltraLite application must specify this version name when it synchronizes to use the generated scripts.
Publications to sync You can specify one or more publications to synchronize.
Output conflict status messages to ASA window This option is useful during development.
Emit calls to drop tables and procedures before definition Check this box if you intend to run the generated SQL script against a database that already contains a previous version of these tables and procedures, and you want to override the definitions with a new set.
Generated SQL Choose the objects you wish to generate. If you have already generated table definitions (for example) you may not wish to re-generate them.
Generated SQL file Specify a file name for the generated SQL file. Once generated, you can run the SQL file against an Adaptive Server Anywhere database from Interactive SQL to create or modify the consolidated database.