7.3.1 Validate MS SQL Server Database
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","mssql"],
["server","host_name"],
["port","port_number"],
["dbname","database_name"],
["user","db_user_name"],
["password","db_user_password"]
]
}
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"
}
CLI Syntax:
repcli validate database=source|target dbtype=mssql \
server=databaseHost port=databasePort \
user=username password=password \
dbname=databaseName
The input parameters are:
- database – Database role, the possible values are:
- source – to validate Capture Process Objects
- target – to validate Apply Process Objects
- dbtype – Type of RDBMS, the possible value is mssql
- server – Host name or IP address of the database server
- port – Database port
- dbname – Database name
- user – Database User name
- password – Database User password