Validate Database

To ensure that the source database is ready for replication, you need to validate its configuration and readiness. The validate command is used to check if the database meets all necessary requirements and is properly configured to support replication processes. It helps identify potential issues before initiating the replication process, ensuring a smoother and more reliable setup.

CLI Syntax:

The input parameters are:

• database – Database type. The possible values are - source and target
• dbtype – RDBMS type. The valid values are oracle, mssql, redshift, mysql, postgresql and snowflake
• [Source  or Target database connection parameters] - set of the parameters to specify database connection setting
• [Source database specific parameters] - set of the parameters to specify database connection setting

The details on the “Source database connection parameters” and “Source database specific parameters” are provided here:

• SQL Server as Source
• Oracle as Source

The details on the “Target database connection parameters” are provided here:

• Oracle as Target
• SQL Server as Target
• PostgreSQL as Target
• MySQL as Target
• Snowflake as Target
• Redshift As Target 

REST API:

• Endpoint: https://repstance_url/configure/database
• Method: POST
• Header:
  • Content-Type: application/json
  • X-Token: token
• Body:
  {
    "command":"validate",
    "parameters":[
       ["database","source|target"],
       ["dbtype","{oracle|mssql|redshift|postgresql|mysql|snowflake}"],
       {Source or Target database connection parameters},
       {Source database specific parameters}
    ]
  }

Server response:

• HTTP Status – status of the command, possible codes are:
  • 200 – if no error occurs
  • 422 – if error occurs
• Body:
  {
   "Status":"{Valid|Invalid}",
   "Message":"The command execution details"
  }