Configure Dbvisit Replicate: Quick Overview

Owned by Clive Otten (Unlicensed)
Jan 21, 2020

Description

The articles provides a quick overview of the configuration steps and phases for a replication setup different environments.

Configuration Steps

Configuration

Phase 1

  • Dbvisit Replicate configuration is done by running setup wizard on the source server.

  • This setup wizard does not touch source or target database but creates several scripts which we must execute to configure Dbvisit Replicate on source and target Dbs.

  • To ease the task of executing these scripts Dbvisit Replicate creates a master script that executes all scripts. In this way, the user needs only execute one script: <replication_name-all.bat.

  • When the replication_name-all.bat script is executed it loads metadata (creates tables in dbvrep schema and loads data) in the source database and creates empty tables in the target database.

Phase 2

  • Once the replication_name-all.bat script is executed we are ready to start the replication.

  • Starting replication requires starting MINE and APPLY processes.

  • MINE runs on source and APPLY runs on target.

  • To start MINE/APPLY we need the script to start the process and the associated DDC file.

  • So to start MINE, we need the <replication\_name>-run-<sourceserver>.bat file and the <replication\_name>-MINE.ddc file. Similarly, to start APPLY, we need the <replication\_name>-run-<targetserver>.bat file and the <replication\_name>-APPLY.ddc file.

  • APPLY runs on the target server, so we have to move the <replication\_name>-run-<targetserver>.bat file and the <replication\_name>-APPLY.ddc file to that target server.

  • If all files are created under "D:\Rep" folder on the source then we must have same folder on the target and we have to copy the <replication\_name>-run-<targetserver>.bat file and the <replication\_name>-APPLY.ddc file in that location. This can be customised in the setup wizard.

In a Linux environment MINE/APPLY runs as a process. Therefore, we need only two files to start MINE/APPLY:

  1. Shell script to start MINE/APPLY.

  2. MINE/APPLY ddc file.

However, on Windows MINE and APPLY act as services. So we need three files to start MINE/APPLY:

  1. Batch script to create MINE/APPLY services

  2. Batch Script to start MINE/APPLY

  3. MINE/APPLY ddc file.

On Windows we can run MINE/APPLY in the foreground. To do so:

  • Edit the <replication\_name>-run-<targetserver>.bat and <replication\_name>-run-<sourceserver>.batfiles and replace start_service with start

  • Do not run the script to create services and run only above scripts.

Krupesh Desai May 14, 2014 16:09