Use the Prepare User Database dialog to prepare your database for replication. This will grant access rights to the replication user to access the database for modeling and replication.
- Right-click the server, then select Prepare User Database from the context menu of the server.
- Enter the individual user database or schema name in the Database/Schema Name dialog.
- Click OK.
- Enter the DBMS Administrator userid and password in the User ID and Password dialog.
- Click OK.
A summary of the steps that Connect CDC Director takes to prepare the database displays.
- Click OK.
You see a screen with the commands executing and then a message that the process is complete.
- Click OK.