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.
• cdcenable – Specifies the scope of Data Definition Language (DDL) changes captured and replicated from the source Microsoft SQL Server database.
  • all - Captures every DDL statement executed on the source database.What is tracked: Tables, primary keys, indexes, views, stored procedures, functions, triggers, synonyms, user permissions, and schema alterations. Best for: Comprehensive database replication, disaster recovery environments, and full schema synchronization.
  • basic - Restricts DDL tracking strictly to core structural layout components.What is tracked: Tables (CREATE/ALTER/DROP), primary keys, and indexes. Default value is basic

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.