Creating a Synchronized System
Page 3 of 6

Steps for Creating a Synchronized System

Follow these steps to create a basic synchronized system:

  1. Create a source database by setting the database connection URL attribute createSource=true. (You can also convert a non-source database to a source database using the convertToSource=true attribute).

    See URL Attributes for Synchronization for details on createSource and convertToSource.

  2. Connect to the source database. (Steps 1 and 2 are typically combined in a single line of code, since when you create the database you start a connection to it.)
  3. Create tables in the source database and populate them with data.
  4. Create a publication in the source database, using the CREATE PUBLICATION statement. See CREATE PUBLICATION for details.
  5. Still at the source database, specify any publication parameters and copy the published dictionary objects and data to a file, using the COPY PUBLICATION statement. See COPY PUBLICATION for details.
  6. If necessary, move the copy file to the machine where you will create the target.
  7. Create a target database, most likely in a different JVM from the source, by setting the createTargetFrom=copyFileName attribute to the path of the copy file or URL of a servlet that returns the copy file.

NOTE: Do not enclose the copy file name in single quotes (').

See URL Attributes for Synchronization for more details.

Once you complete these steps, you have created a source database and an associated read-write, refreshable target database.

NOTE: You can also create source and target databases, tables, and publications using the graphical Cloudview environment. Consult Cloudview's online help system for more information.

For an example illustrating these steps, see Sample Code for Creating a Synchronized System.