Repstance User Guide

Repstance is a real-time data propagation tool: a Capture Process reads the changes of a Source database and an Apply Process writes them to a Target database. This guide shows how to deploy Repstance on AWS, Azure or your own infrastructure, how to configure and run replication with the repcli command line, the REST API or the Web UI, and what every command and parameter does.

Start here

• ABOUT REPSTANCE – what Repstance does and how the Capture and Apply Processes work together
• SUPPORTED DATABASE REQUIREMENTS – the Source and Target databases, their versions and requirements, and which edition supports which
• GETTING STARTED WITH REPSTANCE – launch Repstance from the AWS or Azure Marketplace, or install it on-premises
• CONFIGURE REPLICATION WITH REPSTANCE – worked examples: basic, multi-target and bi-directional replication, initial load, transformation

Use Repstance

• INTERACTING WITH REPSTANCE SERVER – the repcli command line, the REST API and the Web UI
• REPSTANCE WEB USER INTERFACE – set up, monitor, stop, edit and remove replication in the browser
• DATA COMPARISON – check that the Target holds the same data as the Source, and repair the differences
• REPSTANCE SERVER MAINTENANCE – start, stop, update, back up and clean up the server
• MONITORING WITH AMAZON CLOUDWATCH – send the state and the speed of every process to Amazon CloudWatch, with a dashboard and alarms for a process that stops, fails or falls behind
• MONITORING WITH AZURE MONITOR – send the state and the speed of every process to Azure Monitor, with a workbook and alerts for a process that stops, fails or falls behind
• TROUBLESHOOTING AND FAQ – what to do when a process fails or does not start, answers to the usual questions, data type conversion, and what to send to support

Command reference

• DATABASE CONFIGURATION COMMANDS – prepare, validate and remove the Repstance objects in a database
• PROCESS CONFIGURATION COMMANDS – prepare, alter, show, validate and remove Capture and Apply Processes, with the parameters for each database
• PROCESS CONTROL COMMANDS – run, stop, check, reset and report on the processes
• GLOSSARY – the terms of this guide