Contents Index -x option -ze option

MobiLink Synchronization Reference
  MobiLink Synchronization Server Options
    MobiLink synchronization server
      dbmlsrv9 options

-za option

Function 

Generates statement-based scripts that perform a simple snapshot synchronization.

Syntax 

dbmlsrv9 -c "connection-string" -za

Description 

The following scripts are generated:

This option generates active scripts; that is, they are used for the current synchronization. The scripts are also saved and will work for subsequent synchronizations using the same script version. The -za option is typically used for quick demos. To generate scripts as a starting point for writing your own scripts, the dbmlsrv9 -ze option might be more useful.

To generate scripts, you must also specify that the client sends column names. You do this when you initiate synchronization. For Adaptive Server Anywhere remotes, see SendColumnNames (scn) extended option. For UltraLite remotes, see Send Column Names synchronization parameter.

The generated scripts perform one-to-one snapshot synchronization using the table and column names sent from the client. If the consolidated database has different table or column names than the remote, activating these scripts will cause an error during the synchronization.

Note: 
Scripts are generated the first time that a remote synchronizes with a script version that doesn't exist. If the given script version already exists, -za has no effect. This means that you cannot use -za to generate scripts one table at a time for the same script version. Using -za, you must generate scripts for all tables and publications at once.
See also 

-ze option

Example 

The following dbmlsrv9 command enables automatic script generation. The dbmlsync command sets the necessary SendColumnNames option.

dbmlsrv9 -c "dsn=YourDBDSN" -za
dbmlsync -c dsn=dsn_remote -e "SendColumnNames=ON"

Contents Index -x option -ze option