SQL Azure Export / Backpac ?

I have Database on Azure SQL. I created a backup resulting in a backpac file.
I have two questions:

1. Azure says the db is about 24 Gig, but the backpac size is 1.5 Gig - is this probable?

2. I have a local SQL Server Express 2016 on which I have created the same db as I have on Azure (by generating and running scripts to create the schema) and I want to import this backpac to this local db. How do I do this?
LVL 1
Jess31Asked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
SQL Database Import/Export Service creates a logical backup (BACPAC) file containing the schema definition and table data of a database in Windows Azure SQL Database just like we have .bak file in SQL SERVER.
1
 
Pawan KumarDatabase ExpertCommented:
Hi,

1. Yes it is possible.

2. For the 2nd option -- use below URL <<Import a BACPAC File to Create a New User Database>>

https://msdn.microsoft.com/en-IN/library/hh710052.aspx

Hope it helps!!
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Azure says the db is about 24 Gig, but the backpac size is 1.5 Gig - is this probable?
What's "backpac"? Should be backup?
How are you getting the information about those sizes?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ah, ok.
I need to get more into Azure :)

And it looks like a .bacpac file is a compressed backup so this can justify the size differences (24GB unpacked and 1.5GB packed).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.