|
Use the dbmlsync utility to synchronize SQL Anywhere remote databases with a consolidated database. To run dbmlsync you must have the SYS_RUN_REPLICATION_ROLE system privilege.
dbmlsync [ options ] [ transaction-logs-directory ]| Option | Description |
|---|---|
| @ data | Read in options from the specified environment variable or configuration file. |
| -a | Do not prompt for input again on error. |
| -ap parameter,... | Specify authentication parameters. |
| -ba filename | Apply a download file. |
| -bc filename | Create a download file. |
| -be string | When creating a download file, add a string. |
| -bg | When creating a download file, make it suitable for new remotes. |
| -bk | Enables background synchronization. |
| -bkr number | Specifies the number of times dbmlsync will retry synchronization after a background synchronization is interrupted. |
| -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. |
| -ci size | Sets the initial size of the dbmlsync cache. |
| -cl size | Set the minimum size threshold for the dbmlsync cache file. |
| -cm size | Set the maximum size limit for the dbmlsync cache file. |
| -d | Drop any other connections to the database whose locks conflict with the articles to be synchronized. |
| -dc | Continue a previously failed download. |
| -dl | Display log messages on the dbmlsync messages window. |
| -do | Disables scanning of offline transaction logs. This utility option cannot be used with the -x utility option. |
| -drs bytes | For restartable downloads, specify the maximum amount of data that may need to be re-sent after a communications failure. |
|
-ds |
Perform a download-only synchronization. |
| -e "keyword=value"... | Specify extended options. |
| -eh | Ignore errors that occur in hook functions. |
| -ek key | Specify the remote database encryption key. |
| -ep "keyword=value" | Prompt for the remote database encryption key. |
| -eu | Specify extended options for upload defined by most recent -n option. |
| -is | Ignore schedule. |
| -k | Close window on completion. |
| -kpd | In the event of a download failure, saves the information required to attempt restarting the download. |
| -l | List available extended options. |
|
-mn password |
Specify new MobiLink password. |
|
-mp password |
Specify MobiLink password. |
| -n "name,..." | Specify synchronization publication name(s). |
| -o filename | Log output messages to this file. |
| -os size | Specify a maximum size for the message log file, at which point the log is renamed. |
| -ot logfile | Delete the contents of the message log file and then log output messages to it. |
| -p | Disable logscan polling. |
| -pc[ + | - ] | Maintain an open connection to the MobiLink server between synchronizations. |
| -pi | Test that you can connect to MobiLink. |
| -po port | Specifies the port on which dbmlsync listens. |
| -pp number | Set logscan polling period. |
| -q | Run in minimized window. |
| -qc | Shut down dbmlsync when synchronization is finished. |
| -qi | Starts dbmlsync in quiet mode with the window completely hidden. |
| -r[ a | b ] | Use client progress values for upload retry. |
| -s name | Specify synchronization subscription name(s). |
| -sc | Reload schema information before each synchronization. |
| -sm | Causes dbmlsync to start in server mode. |
| -sp sync-profile | Add options from the synchronization profile to the synchronization options specified on the command line. |
| -ts session-name(session-option=option-value[;...]) | Sets up a MobiLink client tracing session. |
| -tu | Perform transactional upload. |
| -u ml_username | Specify the MobiLink user to synchronize. |
| -ud | For Unix only. Run dbmlsync as a daemon. |
| -ui | For Linux with X window, starts dbmlsync in shell mode if a usable display isn't available. |
| -uo | Perform upload-only synchronization. |
| -urc row-estimate | Specify an estimate of the number of rows to upload. |
| -ux | For Solaris and Linux, open the dbmlsync messages window. |
| -v[ levels ] | Verbose operation. |
| -wc classname | Specify a window class name. |
| -x [ size ] | Rename and restart the transaction log. Use the optional size parameter with the -x option to control the size of the transaction log. |
| transaction-logs-directory | Specify the location of the transaction log. See Transaction Log File, below. |
Run dbmlsync to synchronize a SQL Anywhere remote database with a consolidated database.
To locate and connect to the MobiLink server, dbmlsync uses the information from the publication, synchronization user, synchronization subscription, or the dbmlsync command line.
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. Specify this parameter if the transaction log archive files are in a different directory than the active transaction log.
There are also dbmlsync client stored procedures that can help you customize the synchronization process.
For more information about using dbmlsync, see the documentation for synchronization initiation.