Basic Replication Configuration

The following steps are to setup simple one-direction replication between two SQL Server databases, assuming that Repstance is up and running and has access to both Source and Target databases having “dbo” schema with the same set of tables and data. In this example we configure replication using repcli tool, however the same configuration can be implemented via Web User Interface or REST API.

Invoke "repcli" Utility

Use SSH protocol to connect to the Repstance Server and run repcli command to enter “Fully Interactive Mode“:

Configure Source Database

The Capture Process requires minimal set of the Repstance’s objects to be installed in the Source Database. To simplify the configuration process Repstance implements the "prepare database" command that creates all the objects needed for the process. The command is also used to generate SQL script to be run directly in the database. 

Run the “prepare database” command to configure Source database:

The “database=source” parameter instructs Repstance to create "Capture" objects, the “dbtype=mssql”  says that the RDBMS type is SQL Server (see Prepare Source Database for the details) and the rest of the parameters are to provide connectivity details. 

Configure Capture Process

Run the following repcli command to create the Capture Process:

The  “id=1” specifies Capture ID, that is used to start, stop, modify or delete the process and the "name=rep1"  provides name of the Capture Process that is used by Apply Process/Processes to “link” this Capture Process (see Prepare Capture Process for more details).

The “dmlinclude=dbo.%”  and “ddlinclude=dbo.%”  tells Repstance to replicate all DML and DDL changes in the “dbo” schema. See Capture Objects Specification for the details.

Configure Target Database 

Likewise the Source database the Target database should be prepared.

Run the following repcli command to prepare Target database:

You can find more details on how to prepare SQL Server or any other databases as a Target in chapter Prepare Target Database.

Configure Apply Process

Run the following repcli command to create Apply Process:

The “capturename=rep1”  is to connect the Apply Process to the “rep1” Capture Process, while rest of parameters are similar to the Capture Process ones.

See chapter Prepare Apply Process for more details.

Start the Processes 

Once the processes are configured run the following commands to start the processes, that is to start the replication:

Monitor Replication Status

Use “status” command to view the replication details: