Database Configuration

The Database Configuration form is to configure both Source and Target Databases, which are used by Repstance’s Processes. As a part of database configuration, the following commands can be executed:

• Prepare database. This command is used to “prepare” either Source or Target database, by meaning that some replication functionality needs to be enabled and the Repstance’s objects to support the replication need to be installed.

Note: Both Source and Target Databases must be configured before running any replication process

• Remove database. This command is used to remove any replication functionality and Repstance’s objects, which are installed by running the “prepare” command.
• Validate database. The command is used to check if the database has all necessary Repstance’s objects and can be safety used by Repstance’s Processes.

More details on these commands are described in chapter Database Configuration Commands.

The “Database Configuration” is located on the top panel and opens the “Database Maintenance” form.

The form contains the following group of items:

1. Identify if the Database is “Source” or “Target”, or both.
2. Select type of the database engine.
   • The following database types can be selected for a Source Database:
     • Oracle
     • MS SQL Server
   • The following database types can be selected for a Target Database:
     • Oracle
     • MS SQL Server
     • PostgreSQL
     • MySQL
     • Redshift
     • Snowflake
3. The database parameters. Depending on selected database type the different set of inputs to be displayed.
4. This link is used to generate JSON for “prepare”, “validate” and “remove” commands, which is valid JSON for appropriate REST API command (see chapter REST API for more details).
5. The buttons to execute “prepare”, “validate” or “remove” commands. Once the command is executed the status is provided.

Note: MySQL, PostgreSQL, Redshift and Snowflake are supported in Repstance Advanced Edition only.