The following parameters are valid for the “prepare”, "validate" and “remove” database commands for SQL Server Source database:
General Parameters
database – The only appropriate value is source
dbtype – The appropriate value is mssql
generatesql – This parameter to identify if database objects are to be created (0 - value, default), or the only SQL script creating the objects to be generated (1 value).
Database Connectivity
server – Host name or IP address of the database server
port – Database port
dbname – Database name
user – Database User name
password – Database User password
Database Specific Parameters
housekeeping – This parameter determines how the CDC data will be cleaned up. The possible values are:
0 – data will be cleaned up by an MS SQL job only,
1 – install Repstance job to clean up data only after extraction and keep MS SQL cleanup job, which is a time based CDC setting,
2 – install Repstance job and remove SQL Server cleanup job, data will be cleaned up only by the Repstance job.
Web UI
All the parameters provided above can be specified using "Database Settings" Web UI form:
Under “Housekeeping” you can select either “Disabled” or “Cleanup CDC Tables” or“Cleanup CDC Tables and Disabled SQL Server housekeeping”, that are equivalent to 0,1 and 2 of the repcli's housekeeping parameter.