Overview

The Relational Population Service (RPS) provides automatic replication of objects from a production JADE database to a relational database when running an RPS node.

The Relational Population Service wizard provides facilities that enable you to map classes, properties, and column-mapping methods to the required relational tables and columns.

The RPS mapping becomes part of the schema definition in the JADE database.

The Relational Population Service wizard supports:

• Microsoft SQL Server 2008 and higher

• Mapping a class to a table or to multiple tables

• Mapping of properties to multiple columns

• Mapping a column-mapping method (a method that has no parameters, that returns a non-exclusive object reference or a primitive type, and is not updating) to a table column

• Mapping many-to-many relationships to junction tables

• Mapping a class and its subclasses to a single table

• Historical table mode, where each transaction is preserved

For considerations when using RPS to replicate a production JADE database to one or more Relational Database Management System (RDBMS) target databases, see Chapter 2, "Relational Population Service (RPS) Support", in the JADE Synchronized Database Service (SDS) Administration Guide.

For details about patch control for RPS mappings, see "Patch Control for RPS Mappings", in Chapter 3 of the JADE Development Environment Administration Guide.