gCloud SQL import bacpac file for SQL Server

Question

I have a .bacpac file exported from an Azure SQL Server database and I want to import that into GCP Cloud SQL.

As I understand, cloud SQL has the gcloud sql import bak command that allows you to do this but this only supports .bak files as opposed to .bacpac.

Is my understanding correct?

If so, are there are any alternatives to achieve this in GCP?

score 0 · Answer 1 · answered Jul 14 '21 at 15:47

0

According to the documentation, Cloud SQL supports only full backup file, hence bacpac might not be supported. As a workaround I suggest you to install SQL Server on a GCE instance, perform the import there, then finally import again from GCE instance to Cloud SQL.

answered Jul 14 '21 at 15:47

drauedo

641
4
17

right - while that makes sense. However, I need to automate this flow and doing the way you have outlined sounds difficult, if not impossible. – Vikram Jul 15 '21 at 13:50
how did you solve it ? – David Radianu Jul 12 '22 at 09:40

score 0 · Answer 2 · answered Jul 12 '23 at 07:53

By using Azure Automation account and google storage transfer jobs you are able to get an export of your Azure Sql Server database into .bacpac and then import it to google cloud sql server.

You can find the scripts along with details steps on how to import the bacpac files into google cloud here, but a the summary is:

Create a copy of your azure sql database (don’t export directly due to consistency).
Export the copied DB to .bacpac into an azure storage bucket.
Import that .bacpac file into google storage using Google Transfer job
Create a VM in google compute engine and instal Microsoft SQLpackage (it allows to import .bacpac files into sql server)
Spin a SQL Server 2019 in google cloud
Run a script in the VM that imports the .bacpac into the SQL server

gCloud SQL import bacpac file for SQL Server

2 Answers2