Thanks for your reply, how better is it to use the Camel SQL compared to Camel JDBC.
-Regards Srikant On Thu, 10 Dec, 2020, 10:53 Omar Al-Safi, <o...@oalsafi.com> wrote: > 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 > > >
