Lesson 7: Synchronize

Now you are ready to synchronize the remote client for the first time. This is done with the MobiLink client program dbmlsync. Dbmlsync connects to the remote database, authenticates itself with the MobiLink server, and performs all the uploads and downloads necessary to synchronize the remote and consolidated databases based on a publication in the remote database.

To synchronize the remote client

At a command prompt, run the following command, all on one line:

dbmlsync -c "server=remote_eng;dbn=remote_db;uid=DBA;pwd=sql;"
    -n sync_ase_publication
    -u ase_remote -mp ase_pass

dbmlsync is the synchronization application.
server=remote_eng specifies the name of the remote database server.
dbn=remote_db specifies the name of the remote database.
uid is the user name used to connect to the remote database.
pwd is the password used to connect to the remote database.
sync_ase_publication is the name of the publication on the remote device that is used to perform the synchronization. (This publication was created by the Create Synchronization Model Wizard.)
ase_remote is the user name used to authenticate with the MobiLink server.
ase_pass is the password used to authenticate with the MobiLink server.

The progress of the synchronization is displayed in the SQL Anywhere MobiLink Client Messages window. When this command runs successfully, the dbmlsync application populates the remote database with a subset of information from the consolidated database.

If synchronization fails, check the connection information you pass to the dbmlsync application, and the MobiLink user name and password. If the problem persists, check the publication name you used, and ensure the consolidated database and MobiLink server are running. You can also examine the contents of the synchronization logs (server and client).

Note

If you are running the dbmlsync application on a different computer from your MobiLink server, you must also pass in arguments that specify the location of the MobiLink server.

View the data

After successfully synchronizing the remote client to the consolidated database through the MobiLink server, the remote data should be populated with information relevant to one store. You can verify this in Sybase Central using the SQL Anywhere 12 plug-in.

To view the data in the remote database

Start Sybase Central.
Connect to the remote database:
1. On the left pane, right-click SQL Anywhere 12 and choose Connect.
2. In the Authentication dropdown list, choose Database, and then:
  1. In the User ID field, type DBA.
  2. In the Password field, type sql.
3. From the Action dropdown list, choose Connect To A Running Database On This Computer.
4. In theServer Name field, type remote_eng and in the Database Name field, type remote_db.
5. Click Connect.
If the tables created from the consolidated database are not visible, perform the following steps:
1. Right-click remote_db and Configure Owner Filter.
2. Select dbo and click OK.
  
  The tables created from the consolidated database appear in the left pane. Ownership of these tables by dbo is preserved in the remote database.
Choose any remote table and then click the Data tab on the right pane.

In the sales, salesdetail and stores tables, all the records are for the store with an identifier of 5023. This particular store is not concerned with the sales information of other stores. For this reason, you set the synchronization scripts to filter out rows by the remote ID, and you set this database's remote ID to the value of a particular store identifier. Now this particular store's database takes up less space, and requires less time to synchronize. Since the remote database size is kept to a minimum, frequently performed operations such as entering a new sale or processing a refund on a previous sale run faster and more efficiently.