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.