Synchronization—Exercises

Main Exercise

Purpose: The purpose of this lesson is to show how to synchronize data between your server and local database.

Windows:
File Menu

Synchronize- Creating a New Local Database

  1. On the File menu click Synchronize. The Synchronization Wizard will appear.
  2. Select Create a new local database.
  3. Select the database that you created.

Note: If you cannot find the database you created, ask your instructor to create an ODBC Source for you.

  1. Click Next.
  2. Select the Race database you wish to synchronize with and click Next.
  3. Select All data and select the Include external data and Include documents check boxes.
  4. Click Exclude Tables to select which tables you wish to exclude from the synchronization.
  5. Click Start to begin synchronization.
  6. You will get a message once synchronization is finished successfully.
  7. On the File menu, click Change database and logon to your newly created local database. Verify that both data and documents have been transferred. (For e.g. by searching for Customer 1000 and for the activities you created in the document exercise).

Synchronize - An Existing Local Database

  1. On the File menu click Synchronize. The Synchronization Wizard will appear.
  2. Select Synchronize an existing local database.
  3. Your local database will be displayed by default, but you may change it using the Local Database drop-down list.
  4. Click Next.
  5. Select the Race database you wish to synchronize with and click Next.
  6. Select the Include external data and Include documents check boxes. The value in the drop-down list will be the same as when you created the local database and cannot be changed.
  7. Click Exclude Tables to select which tables you wish to exclude from the synchronization. You cannot exclude stand-alone, internal or synchronization replication enabled external tables if you have not excluded them in the initial synchronization. Previously excluded external tables can be included, if needed.
  8. Click Start to begin synchronization.
  9. You will get a message once synchronization is finished successfully.

Note: If the same record has been changed in both the local database and the server database, you will receive a message saying discrepancies were found and you are given the option to open the Synchronizer Discrepancy Utility.