This lab shows you how to implement a simple, yet secured Change Data Capture (CDC) SQL Server database replication topology from AWS into Azure using Enzo DataZen as the technology platform, using a single DataZen instance in AWS. The lab takes about 30 minutes and assumes you have an AWS and an Azure account.

While this lab uses the built-in Synthetic CDC capabilities of DataZen for simplicity, DataZen also supports other forms of CDC for SQL Server, including native CDC and Change Data Capture.

Instructions

Click on this link to download the PDF containing the lab instructions.

Pre-Requisites

To successfully complete this lab, you will need the following:

• An AWS Account
• A Microsoft Azure Account

The following technologies are used in this lab:

• AWS
  • EC2 instance: Use the AWS Marketplace to create an Enzo Server EC2 instance that contains DataZen
  • SQL Server: The EC2 image will contain a SQL Server database; however, you can also use your own RDS database
  • DataZen: DataZen will be installed on the same EC2 instance as part of the lab
• Microsoft Azure
  • Azure SQL Database: Use an Azure SQL Database instance to push changes detected in AWS