This project aims to implement Change Data Capture (CDC) techniques with Python to perform incremental data updates from a SQL Server database to a PostgreSQL database. Change Data Capture is a method used to track changes in a database, allowing for efficient synchronization of data between different database systems.
Clone the project to your machine.
git clone https://github.com/wlcamargo/python_cdc
To set up your development environment, follow these steps:
-
Set up the virtual environment (optional but recommended):
Windows:
python -m venv venv venv\Scripts\activateLinux:
python -m venv venv source venv/bin/activate -
Install dependencies:
pip install -r requirements.txt