topic Re: On premises SQL Server to Big Query in Stitch

On premises SQL Server to Big Query

DataDaddy — Fri, 15 Nov 2024 23:07:06 GMT

HI,

I am new to Stitch. I have a requirement to extract data from a on premises SQL server db and load into BigQuery. Could you please let me know if this can be achieved using Stitch? It looks like it should be possible. If it is, would you mind sharing any links to documentation that you may have?

Thanks

Dann

Re: On premises SQL Server to Big Query

Anonymous — Tue, 02 Mar 2021 16:46:45 GMT

Hi @Dann Westcott ,

Yes, you can do this. Here are some links that might help.....

https://www.stitchdata.com/docs/integrations/databases/microsoft-sql-server

https://www.stitchdata.com/docs/destinations/google-bigquery/v2

Have you seen these?

Regards

Richard

Re: On premises SQL Server to Big Query

CDestiney1627965782 — Tue, 03 Aug 2021 04:44:49 GMT

Hello guys, what want work on a project to solidify my data migration skill.

How can I best move on-Prem sql server data to bigquery?

Here are the additional things to consider,

I am not moving the whole table columns i.e I want to filter out specific columns
If there is a change in the on-prem, the pipeline should be notified or adjust to the changes (can I use airflow here?)
I don't want to use third party platforms (I am just learning, I can't afford additional charges)

Please I will like any contributions

lowes employee portal