SQL Server as Source

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.