8.2.1.1 MS SQL Server Database Configuration
In order to configure MS SQL Server Database select “MS SQL Server” under “Database Type”and enable “Source” or “Target” or both flags under “Database”:
The following parameters should be provided:
- Server– Host name or IP address of the database server
- Port– Database port number
- DB– Database name to be connected to
- Username– Database User name
- Password– Database User password
- Housekeeping – This parameter determines how the CDC data will be cleaned up. The possible values are:
- 0 – data will be cleaned up by an SQL Server job only,
- 1 – install Repstance job to clean up data only after extraction and keep SQL Server 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.
Prev page:
8.2.1 Database ConfigurationNext page:
8.2.1.2 MySQL Database Configuration- Repstance User Guide
- 1. ABOUT REPSTANCE
- 2. GETTING STARTED WITH REPSTANCE
- 3. INTERACTING WITH A REPSTANCE SERVER
- 4. SUPPORTED DATABASE REQUIREMENTS
- 5. HOW TO USE REPSTANCE
- 6. HOW TO REMOVE REPSTANCE
- 7. COMMANDS TO BE USED
- 7.1 Prepare Source and Target Databases
- 7.1.1 Prepare MS SQL Server Database as Source Database
- 7.1.2 Prepare Oracle Database as Source Database
- 7.1.3 Prepare MS SQL Server Database as Target Database
- 7.1.4 Prepare Oracle Database as Target Database
- 7.1.5 Prepare PostgreSQL and Aurora PostgreSQL Databases as Target Database
- 7.1.6 Prepare MySQL and Aurora MySQL Databases as Target Database
- 7.1.7 Prepare Snowflake as Target Database
- 7.2 Remove Repstance Database Objects
- 7.2.1 Remove Repstance Database Objects in MS SQL Server
- 7.2.2 Remove Repstance Database Objects in Oracle
- 7.2.3 Remove Repstance Database Objects in PostgreSQL and Aurora PostgreSQL Databases
- 7.2.4 Remove Repstance Database Objects in MySQL and Aurora MySQL Databases
- 7.2.5 Remove Repstance Database Objects in Snowflake Database
- 7.3 Validate Source and Target Databases
- 7.4 Prepare Capture Process
- 7.4.1 Prepare Capture Process for MS SQL Server Database
- 7.4.2 Prepare Capture Process for Oracle Database
- 7.4.3 Overview of Data Capturing Methods for Oracle Database
- 7.4.4 Capture Objects Specification
- 7.4.5 Initial Load
- 7.4.6 Objects Mapping and Possible Transforms
- 7.4.7 Transformation Rules and Triggering Order
- 7.5 Alter Capture Process
- 7.6 Show Capture Process
- 7.7 Validate Capture Processture Process
- 7.8 Remove Capture Process
- 7.9 Prepare Apply Process
- 7.9.1 Prepare Apply Process for MS SQL Server Database
- 7.9.2 Prepare Apply Process for Oracle Database
- 7.9.3 Prepare Apply Process for PostgreSQL and Aurora PostgreSQL Databases
- 7.9.4 Prepare Apply Process for MySQL and Aurora MySQL Databases
- 7.9.5 Prepare Apply Process for Snowflake
- 7.9.6 Objects Filtering
- 7.10 Alter Apply Process
- 7.11 Show Apply Process
- 7.12 Validate Apply Process
- 7.13 Reset Apply Process
- 7.14 Remove Apply Process
- 7.15 Control Repstance Processes
- 7.1 Prepare Source and Target Databases
- 9. REPSTANCE SERVER MAINTENANCE
- GLOSSARY
On this page