MobiLink Synchronization Reference
MobiLink Synchronization Server Options
MobiLink synchronization server
dbmlsrv9 options
Generates statement-based scripts that perform a simple snapshot synchronization.
dbmlsrv9 -c "connection-string" -za
The following scripts are generated:
upload_insert
upload_update
upload_delete
download_cursor
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. |
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"