On an RPS node, the schema and mapping are defined when you create the RPS node, and you cannot change them.
You can select your RPS mapping on an RPS node only if it is being created from a backup of the primary.
On a primary server, the Select RPS Mapping dialog, shown in the following image, is displayed when you:
First access the RPS Manager application and you have not yet selected an RPS mapping
Click the Change button in the Mapping group box
To select your schema and RPS mapping
In the Schema and RPS Mapping list boxes, select the schema and the RPS mapping defined in that schema whose RPS node you want to use.
In the Database Name text box, specify the name of the target RDBMS database.
The default value is the database name specified in the Default Database Name text box on the Define RPS sheet of the Relational Population Service wizard. (For details, see "
If the target RDBMS database is not specified in the RPS Manager application or the Relational Population Service wizard, an RDBMS error may be raised when you attempt to execute the SQL script.
Click the OK button. Alternatively, click the Cancel button to abandon your selections.