How can I make a copy from an Azure SQL Database into my local ubuntu machine?

Question

I have a SQL Server 2017 running on my Ubuntu 18.04 machine, and I was also provided with a database hosted on Azure.

What I'm trying to do is to get a local copy of that database so that I can work upon it without messing with the real/production database.

Most of the examples I run into are made through the SSMS such as this one.

I also tried this - without success so far.

I've been the whole day trying to figure this out. Any hand on how can I achieve this on a ubuntu machine?

-- EDIT --

When I tried to do what the docs says, I get this error:

Statement 'BACKUP DATABASE' is not supported in this version of SQL Server.

Apparently, it has to do with Azure itself: http://sqlazuretutorials.com/wordpress/sql-statements-not-supported-for-sql-azure/

why without success? what is the problem? please be more precise — Derviş Kayımbaşıoğlu, Jan 18 '19 at 23:16
Sorry, I just explained it a little bit further. See the edit. — germmand, Jan 18 '19 at 23:24
I'm using an ubuntu machine. Therefore I can't use it since it's only available for Windows. — germmand, Jan 18 '19 at 23:36
Export the database to blog storage and download it. Itll give you a bacpac file which you can jmport. — Sage, Jan 19 '19 at 00:00
this has been answered here https://stackoverflow.com/questions/5475306/how-do-i-copy-sql-azure-database-to-my-local-development-server — Stefan Prugg, Jan 19 '19 at 10:04
@StefanPrugg, the problem with that answer is that it requires a Windows environment. I already posted the solution that worked for me. — germmand, Jan 19 '19 at 16:20

score 2 · Accepted Answer · answered Jan 19 '19 at 16:15

2

Basically what I did was that I made use of Azure Data Studio along with its extension SQL Server Import which has this feature for exporting and importing .bacpac files as in SSMS as mentioned here.

answered Jan 19 '19 at 16:15

germmand

1,190
7
9

How can I make a copy from an Azure SQL Database into my local ubuntu machine?

1 Answers1