Materialization

Learn about the subscription materialization issues that you must consider when implementing a replication system with heterogeneous or non-ASE data servers, as well as how to materialize subscriptions to primary tables in a non-ASE database.

Materialization is creating and activating subscriptions and copying data from a primary database to a replicate database, thereby initializing the replicate database.

Before you can replicate data from a primary database, you must set up and populate each replicate database so that the replicate objects (such as tables) are in a state consistent with those in the primary database.

• Types of Materialization
  Replication Server supports two types of subscription materialization.
• Heterogeneous Materialization
  You may use a bulk materialization or automatic materialization, if it applies to materialize subscriptions to primary data in a non-ASE data server.
• Bulk Materialization Options
  There are two bulk materialization options for subscriptions to primary data in a non-ASE database.
• Unload Data from a Primary Database
  The subscription materialization process involves unloading subscription data from the primary table so it can be loaded into the replicate table. Subscription data is the data in the primary table that is requested by the subscription.
• Datatype Translation
  If you are not using the unload utility and are using automatic materialization, then Replication Server performs the translations.
• Load Data Into Replicate Databases
  Part of the subscription materialization process involves loading subscription data from the primary table into the replicate table.
• Atomic Bulk Materialization
  Atomic bulk materialization assumes that all applications updating the primary table can be suspended while a copy of the table is made. The copy is then loaded at the replicate site.
• Nonatomic Bulk Materialization
  Nonatomic bulk materialization assumes applications updating the primary table cannot be suspended while a copy of the table is made.
• Direct Load Materialization
  Use direct load materialization to materialize data between different kinds of primary and replicate databases.