I have an FTP site from a third-party vendor that updates with weekly .bak files and daily .diff files for a Microsoft SQL 2016 database. I do not have access to the original database. My eventual goal is to incorporate some of the data contained in these backups into my BigQuery data warehouse. I would like an automated way to regularly restore this database to a cloud so that I can regularly pull information from it like any other SQL database. The total size of the .bak is less than 5 GB.

I think that Google Cloud has a facility for hosting a SQL database (https://cloud.google.com/sql-server/), but this does not seem to be able to do restores directly from an FTP site. Is there a way to accomplish what I'm trying to do within the Google Cloud ecosystem?

Alternatively, I am happy to host this database as an Azure SQL database; I am just less familiar with the platform. Would I be able schedule regular restores from an FTP site there?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.