Continuous replication from SQL Server to Google's BigQuery

• mTBCent

  SSChasing Mays

  Points: 652

  More actions

  January 10, 2021 at 8:58 am

  #3830542

  Hello everyone,

  I have a need for enabling a continuous flow of data from a SQL Server production server to the Google's BigQuery. There are a lot of commercial tools for such purpose and most of them use CDC-based methods for propagating changes, examples:

  • Striim (https://www.striim.com/striim-for-google-bigquery/)
  • StitchData (https://www.stitchdata.com/integrations/sql-server/google-bigquery/)

  Has anyone had a proven experience that can share with me exporting data to BigQuery from SQL Server with any of these tools?

  Suggestions for any other approaches are highly appreciated.

  Thank you

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 11, 2021 at 9:10 am

  #3830790

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.