TNWiki Article Spotlight – SSIS: Data maintenance with Microsoft Azure SQL Database

Hello and welcome everybody to our TNWiki Article Spotlight on Tuesday.

Lately I had to deal a lot with Extract-Load-Transform (ETL) processes. One problem I met several times is to determine which data has already been transferred to a database and which data needs to be processed next. A typical approach for solving this problem is to add extra fields to a database table or adding a processing flag. When working with a SQL Server there is another way ... Change Data Capture (CDC). Ricardo Lacerda has put together an article which walks you through CDC in a typical scenario: A SQL Server on-premise and one hosted in Microsoft Azure. He explains exactly the need and why typical solutions can be difficult to implement. After a short introduction he sets up the scenario and shows step-by-step how to move your data from one database to another with the help of a SQL Server Integration Services (SSIS) package using CDC.

If you have similar problems in your hybrid infrastructure and would like to see an elegant solution, check out this article!

- German Ninja Jan (TwitterBlogProfile)


Comments (7)

  1. Ricardo, excelente artigo!

  2. Special thanks to Ricardo for writing this great article!

  3. Dear Ed Price,
    I’m really very happy with your closing comments and recognition. I love what I do. It’s a pleasure dedicating my time to help the people with my knowledge.

  4. Ricardo, that’s awesome! We’re glad to have you here in the community!

  5. Saeid Hasani says:

    Long article!
    Thanks for sharing!

  6. Vitor Santos says:

    Dear Lacerda, great article!

Skip to main content