| REPLICATING BETWEEN DIFFERENT DATABASE TYPES |
Databases can differ because they are different DBMS's or because they are of the same type but have different database models. In either case HVR can still replicate between these databases.
Different DBMSs
HVR can replicate between different DBMSs, for example between Oracle, SQL Server and Ingres. It can also replicate between different versions of the same DBMS, for example between Oracle 8 and Oracle 10g. Replication can be in one direction or be "bi-directional". Conversion between corresponding datatypes is done automatically.
Extra, Missing or Renamed Columns
HVR replication can be configured to know that a table or column in one replicated database has a different name in another database. HVR can also replicate between tables where one table has extra columns or some columns are missing.
Restrictive Replication
HVR has an option to replicate only some changes on a given table or to ignore changes to other rows. This can be used, for example, to allow old rows to be purged from the production database but to be kept in a reporting database or a data warehouse.
Performance is Unchanged
Maximum performance is maintained regardless of whether HVR is used in a homogeneous environment (databases from one vendor) or a heterogeneous environment (databases from different vendors).
|
