Hi, To write your events to your target Azure SQL server database, you can use Camel JDBC <https://camel.apache.org/components/latest/jdbc-component.html> component since Azure SQL supports JDBC uses JDBC driver to connect to the database. Plus Camel Debezium SQL Server, I'd recommend using something like Azure Eventhub as event messaging medium in order to retain the events for some period of time in case of failures .. etc, hence your pipeline may look like this: Azure SQL DB (live) -> Camel Debezium SQL Server -> Azure Eventhub -> Camel JDBC -> Azure SQL DB (replication).
There are few examples that can help you to get started: - Debezium with AWS Kinesis and Cassandra Example <https://github.com/apache/camel-examples/tree/master/examples/camel-example-debezium> . - Debezium with Azure Eventhubs with Azure Storage Blob Example. <https://github.com/apache/camel-examples/tree/master/examples/camel-example-debezium-eventhubs-blob> - Camel JDBC Example <https://github.com/apache/camel-examples/tree/master/examples/camel-example-jdbc> . I hope it helps! Regards, Omar On Thu, Dec 10, 2020 at 8:47 AM SRIKANT MVS <srikant....@gmail.com> wrote: > Team, > I have a usecase where I need to replicate data for a specific duration > from one Azure SQL DB (subscription1) to another Azure SQL DB > (supbscription2). > > The source DB has live data with continuous inserts, updates and deletes > possibility. Henceforth, we will miss the updates while performing DB copy > operations. > > For consuming the messages, I am considering to use Debizium SQL Server > Connector > < > https://camel.apache.org/components/latest/debezium-sqlserver-component.html > >, > but this component > > *supports only the consumer functionality* > > Which camel component can I use to produce the same event to the > destination DB ?? > > -Srikant >
