Example of basic replication configuration
The following example demonstrates how to setup simple DML and DDL replications between two MS SQL Server databases for all objects located in the dbo schema using repcli tool:
repcli>prepare database=source dbtype=mssql server=source.repstance.com port=1433 user=ds password=secret dbname=sdemo
[Completed]: Database [source.repstance.com:1433,sdemo] has been prepared
repcli>prepare database=target dbtype=mssql dbtype=mssql server=target.repstance.com port=1433 user=ds password=secret dbname=tdemo
[Completed]: Database [target.repstance.com:1433,tdemo] has been prepared
repcli>validate database=source dbtype=mssql server=source.repstance.com port=1433 user=ds password=secret dbname=sdemo
[Valid]: Database SDEMO is valid
repcli>validate database=target dbtype=mssql server=target.repstance.com port=1433 user=ds password=secret dbname=tdemo
[Valid]: Database TDEMO is valid
repcli>prepare process=capture dbtype=mssql id=1 name=rep1 server=source.repstance.com port=1433 user=ds password=secret dbname=sdemo dmlinclude=dbo.% ddlinclude=dbo.%
[Completed]: Capture 1 has been added
repcli>validate process=capture id=1
[Valid]: Capture process 1 is valid
repcli>run process=capture id=1
[In Process]: Command [RUN] has been sent. Use [status] command to monitor the Capture 1 process
repcli>prepare process=apply id=1 dbtype=mssql capturename=rep1 server=target.repstance.com port=1433 user=ds password=secret dbname=tdemo repuser=1
[Completed]: Apply 1 has been added
repcli>validate process=apply id=1
[Valid]: Apply process 1 is valid
repcli>run process=apply id=1
[In Process]: Command [RUN] has been sent. Use [status] command to monitor the Apply 1 process
repcli>status
Capture Process 1, Name: rep1, DB: sdemo, Server: source.repstance.com
RUN (In Process), Waiting for Transactions
Last Source DB Change : 2019/02/25 21:13:00.173 UTC (0x00000044000002AE0004)
Last Captured DB Change : 2019/02/25 21:13:00.173 UTC (0x00000044000002AE0004)
Total since 2019/02/25 21:10:00.983 UTC (0x000000440000020A0004):
Processing the Transactions : 00:00:05.289
Waiting for Transactions : 00:02:44.396
Average Speed (ops) : 1.134
Transactions: 6 (DDL: 0, Delete: 3, Insert: 3, Update: 0)
Apply Process 1, Transactions Provider (Capture): rep1, DB: tdemo, Server: target.repstance.com
RUN (In Process), Waiting for Transactions
Last Source DB Change : 2019/02/25 21:13:00.173 UTC (0x00000044000002AE0004)
Last Applied DB Change : 2019/02/25 21:13:00.173 UTC (0x00000044000002AE0004)
Lag : 00:00:00.000
Total since 2019/02/25 21:13:00.150 UTC (0x00000000000000000001):
Processing the Transactions : 00:00:02.065
Waiting for Transactions : 00:00:08.284
Average Speed (ops) : 2.905
Transactions: 6 (DDL: 0, Delete: 3, Insert: 3, Update: 0)
Prev page:
Basic Replication ConfigurationNext page:
Multi-Target replication configuration- Repstance User Guide
- 1. ABOUT REPSTANCE
- 2. SUPPORTED DATABASE REQUIREMENTS
- 3. GETTING STARTED WITH REPSTANCE
- 4. INTERACTING WITH A REPSTANCE SERVER
- 6. DATABASE CONFIGURATION COMMANDS
- 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.1 Remove Repstance Database Objects in MS SQL Server
- 7.2 Remove Repstance Database Objects [TBR]
- 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.1 Prepare Source and Target Databases
- 7. PROCESS CONFIGURATION COMMANDS
- 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.4 Prepare Capture Process
- 6.1 How to remove Apply Process
- 6.2 How to remove Capture Process
- 8. REPSTANCE WEB USER INTERFACE
- 9. REPSTANCE SERVER MAINTENANCE
- GLOSSARY
On this page