Skip to main content

SQL Server Azure Setup

Here is everything you need to do before creating a SQL Server resource and using Azure.

Networking

Before you can add, the SQL Server instance needs to be accessible by Meroxa. You may Connect use SSH Tunneling or Connect directly and only allow Meroxa IPs.

To configure the Meroxa IPs in Azure:

  1. Navigate to your MS SQL Server in the Azure Portal.
  2. Select "Firewalls and virtual networks"

Azure SQL Server Firewall

  1. Add Meroxa IPs.
  2. Save the new configuration.

Enable Change Data Capture

For changes to be captured, CDC support must be enabled for the SQL Server database and every table.

See Azure Documentation for more: Enable and disable change data capture .