I need to move data from on-prem SQL Server to GCS bucket, I am trying to explore the options at hand. Based on my research I believe I should use "an external tool" like Informatica / Talend to Copy data from on-prem SQL to GCS.
I am expecting some options which I can use to satisfy the use case.
Note: Being an Azure user, I was expecting a utility like "Copy Data" which would enable me to copy data.
The Google Cloud Storage Transfer Service?
Need your docker and an agent to make the transfer from your GCP?
Remember you need to enable your Google Cloud Transfer API, then enable the Pub/Sub API. Don't forget to set the correct policies for your project to gain access to your account cloud storage. Look at your IAM roles?