Use the dbmlsync utility to synchronize SQL Anywhere remote databases with a consolidated database.
Syntaxdbmlsync [ options ] [ transaction-logs-directory ]| Option | Description |
|---|---|
| @data | Read in options from the specified environment variable or configuration file. See @data dbmlsync option. |
| -a | Do not prompt for input again on error. See -a dbmlsync option. |
| -ap | Specify authentication parameters. See -ap dbmlsync option. |
| -ba filename | Apply a download file. See -ba dbmlsync option. |
| -bc filename | Create a download file. See -bc dbmlsync option. |
| -be string | When creating a download file, add a string. See -be dbmlsync option. |
| -bg | When creating a download file, make it suitable for new remotes. See -bg dbmlsync option. |
| -bk | Enables background synchronization. See -bk dbmlsync option. |
| -bkr | Controls dbmlsync behavior after a background synchronization is interrupted. See -bkr dbmlsync option. |
| -c connection-string | Supply database connection parameters in the form parm1=value1; parm2=value2,... that are used to connect to the remote database. If you do not supply this option, a window appears and you must supply connection information. See -c dbmlsync option. |
| -ci size | Sets the initial size of the dbmlsync cache. See -ci dbmlsync option. |
| -cl size | Set the minimum size threshold for the dbmlsync cache file. See -cl dbmlsync option. |
| -cm size | Set the maximum size limit for the dbmlsync cache file. See -cm dbmlsync option. |
| -d | Drop any other connections to the database whose locks conflict with the articles to be synchronized. See -d dbmlsync option. |
| -dc | Continue a previously failed download. See -dc dbmlsync option. |
| -dl | Display log messages on the dbmlsync messages window. See -dl dbmlsync option. |
| -do | Disables scanning of offline transaction logs. See -do dbmlsync option. |
| -drs bytes | For restartable downloads, specify the maximum amount of data that may need to be resent after a communications failure. See -drs dbmlsync option. |
|
-ds |
Perform a download-only synchronization. See -ds dbmlsync option. |
| -e "option=value"... | Specify extended options. See MobiLink SQL Anywhere client extended options. |
| -eh | Ignore errors that occur in hook functions. |
| -ek key | Specify the remote database encryption key. See -ek dbmlsync option. |
| -ep | Prompt for the remote database encryption key. See -ep dbmlsync option. |
| -eu | Specify extended options for upload defined by most recent -n option. See -eu dbmlsync option. |
| -is | Ignore schedule. See -is dbmlsync option. |
| -k | Close window on completion. See -k dbmlsync option (deprecated). |
| -l | List available extended options. See -l dbmlsync option. |
|
-mn password |
Specify new MobiLink password. See -mn dbmlsync option. |
|
-mp password |
Specify MobiLink password. See -mp dbmlsync option. |
| -n name | Specify synchronization publication name(s). See -n dbmlsync option (deprecated). |
| -o logfile | Log output messages to this file. See -o dbmlsync option. |
| -os size | Specify a maximum size for the message log file, at which point the log is renamed. See -os dbmlsync option. |
| -ot logfile | Delete the contents of the message log file and then log output messages to it. See -ot dbmlsync option. |
| -p | Disable logscan polling. See -p dbmlsync option. |
| -pc+ | Maintain an open connection to the MobiLink server between synchronizations. See -pc+ dbmlsync option. |
|
-pd dllname;... |
Preload specified DLLs for Windows Mobile. See -pd dbmlsync option. |
| -pi | Test that you can connect to MobiLink. See -pi dbmlsync option. |
| -po | Specifies the port on which dbmlsync listens. See -po dbmlsync option. |
| -pp number | Set logscan polling period. See -pp dbmlsync option. |
| -q | Run in minimized window. See -q dbmlsync option. |
| -qc | Shut down dbmlsync when synchronization is finished. See -qc dbmlsync option. |
| -r[ a | b ] | Use client progress values for upload retry. See -r dbmlsync option. |
| -s name | Specify synchronization subscription name(s). See -s dbmlsync option. |
| -sc | Reload schema information before each synchronization. See -sc dbmlsync option. |
| -sm | Causes dbmlsync to start in server mode. See -sm dbmlsync option. |
| -sp sync profile | Add options from the synchronization profile to the synchronization options specified on the command line. See -sp dbmlsync option. |
| -tu | Perform transactional upload. See -tu dbmlsync option. |
| -u ml_username | Specify the MobiLink user to synchronize. See -u dbmlsync option (deprecated). |
| -ud | For Unix only. Run dbmlsync as a daemon. See -ud dbmlsync option. |
| -ui | For Linux with X window, starts dbmlsync in shell mode if a usable display isn't available. See -ui dbmlsync option. |
| -uo | Perform upload-only synchronization. See -uo dbmlsync option. |
| -urc row-estimate | Specify an estimate of the number of rows to upload. See -urc dbmlsync option. |
| -ux | For Solaris and Linux, open the dbmlsync messages window. See -ux dbmlsync option. |
| -v[ levels ] | Verbose operation. See -v dbmlsync option. |
| -wc classname | Specify a window class name. See -wc dbmlsync option. |
| -x | Rename and restart the transaction log. See -x dbmlsync option. |
| transaction-logs-directory | Specify the location of the transaction log. See Transaction Log File, below. |
RemarksRun dbmlsync to synchronize a SQL Anywhere remote database with a consolidated database.
To locate and connect to the MobiLink server, dbmlsync uses the information on the publication, synchronization user, synchronization subscription, or the dbmlsync command line.
Transaction log file The transaction-logs-directory is the directory that contains the transaction log for the SQL Anywhere remote database. There is an active transaction log and zero or more transaction log archive files, all of which may be required by dbmlsync to determine what to upload. You must specify this parameter if the following are all true:
the contents of the working log file have been truncated and the file has been renamed since you last synchronized
you run the dbmlsync utility from a directory other than the one where the renamed log files are stored
For more information, see Transaction log files.
dbmlsync event hooks There are also dbmlsync client stored procedures that can help you customize the synchronization process. For more information, see Introduction to dbmlsync hooks and Event hooks for SQL Anywhere clients.
Using dbmlsync For more information about using dbmlsync, see Initiating synchronization.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |