Synchronization model files are located in the MobiLink project directory. A synchronization file has the file extension .mlsm. When you deploy a synchronization model, a directory starting with your model name and ending with _deploy is created.
Depending on the deployment options you chose, you might have the following files:
| File | Description |
|---|---|
| cons_setup.bat |
A batch file that runs the SQL file to set up the consolidated database. |
| cons_setup.sql | A SQL file for setting up the consolidated database. |
| mlsrv.bat |
A batch file for running the MobiLink server. |
| remote_setup.bat |
A batch file that runs the SQL file to set up the remote database. |
| remote_setup.sql | A SQL file for setting up the consolidated database. |
| summary.txt | A file that summarizes the details of the synchronization model. |
| sync.bat | If you deployed a SQL Anywhere remote database, then this is a batch file for synchronizing SQL Anywhere databases with dbmlsync. |
| modelname_remote.db | If you chose to create a new SQL Anywhere remote database, then this is the database file. |
| modelname_remote.udb | If you chose to create a new UltraLite remote database, then this is the database file. |
| modelname_ulsync.bat | If you deployed an UltraLite database, then this is a batch file for testing synchronization with an UltraLite remote database using the ulsync utility. |
Running the batch filesRun the batch files that are created by the Deploy Synchronization Model Wizard from the command line to synchronize your synchronization model.
Prérequis
You must have a synchronization model.
Contexte et remarques
If you have not yet run MobiLink setup scripts on the consolidated database, run them before deploying. See Consolidated database setup.
To run many of the batch files, you must include connection information. You may also need to create ODBC data sources before running these batch files. See ODBC data sources.
TaskWhen you ran the Deploy Synchronization Model Wizard, if you chose to create a file to run later (on the Choose How To Prepare Databases For Synchronization page), then you must run the batch file that is located in the project-name_deploy sub-folder of your model. This file creates all the objects you chose to have created in the consolidated database, including synchronization scripts, shadow tables, and triggers. It can also register MobiLink users in the consolidated database.
To run this file, navigate to the project-name_deploy directory and run the file cons_setup.bat or cons_setup.sh. You must include connection information on the command line. For example, run:
cons_setup.bat "DSN=MY_ODBC_DATASOURCE" |
When you ran the Deploy Synchronization Model Wizard, if you chose to create a file to run later (on the Choose How To Prepare Databases For Synchronization page), then you must run the batch file in the project-name_deploy directory. This file creates all the objects you chose to have created in the remote database, including tables, publications, subscriptions, and MobiLink users.
To run this file, navigate to the project-name_deploy directory and run the file remote_setup.bat or remote_setup.sh. For example, run:
remote_setup.bat |
You are prompted for a password if you are using an existing remote database.
Start the MobiLink server by running mlsrv.bat. You must include connection information for the consolidated database on the command line. For example, run:
mlsrv.bat "DSN=MY_ODBC_DATASOURCE" |
Synchronize.
For a SQL Anywhere remote database:
Grant the SYS_RUN_REPLICATION_ROLE system role to a user to be able to run dbmlsync. For example, execute the following in Interactive SQL:
GRANT ROLE SYS_RUN_REPLICATION_ROLE TO userid |
Connect as that user to the database.
Start the remote database that is located in the project-name_deploy directory. For example, run:
dbsrv16 MyModel_remote.db |
Start dbmlsync, the SQL Anywhere MobiLink client. Run the file sync.bat in the project-name_deploy directory. You must include connection information on the command line. For example, run:
sync.bat "UID=userid;PWD=password;SERVER=MyModel_remote" |
For an UltraLite remote database:
To test your synchronization, run the file that ends with _ulsync.bat in the remote directory.
Alternatively, run your UltraLite application.
See also |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |