Hi Team, We have a requirement of replicating the data from MSSQL Source database to MSSQL target database.
We are using SQL Server 2014 Web edition as the source database and target database as well. We want to replicate the data from Source database to target database realtime. Enabled the change tracking on the SQL Server Database side as change data capture is not supported in web edition of SQL Server 2014. So we are using Kafka Connect to read the changes (updates/inserts) from the source database and then push them to target database in realtime. Could you help us in getting if any Kafka connectors for MSSQL to Kafka and Kafka to MSSQL are available for the above scenario. We are open for any suggestions as well for the above requirement. Thanks Harish