[google-cloud-sql-discuss] Re: AUTOMATING Export and Import Of tables For CLOUD SQL postgresql database

Hi Aref,

Thank you so much for this reply. I apologize for the late feedback. Ended up creating a VM in Compute Engine, creating a network route to my On Prem Database and then another to the CloudSQL postgres instance and storage bucket in GCP. Used a paasword file on The VM to store Hostname, Username, and passwords. Used crontab to automate the bash script I created on the VM.

Backups up tables on-prem ------ transfer file from on prem to GCO storage bucket ------ connects to Cloud SQL database, truncates tables ------ import data from stored file in bucket. Works so well.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/878c2702-6ad9-4507-9b2f-ddd823fa608e%40googlegroups.com.