<div>
Hi,<br />
<br />
1. Yes it is possible.<br />
<br />
2. For the 2nd option -- use below URL &lt;&lt;Import a BACPAC File to Create a New User Database&gt;&gt;<br />
<br />
<a href="https://msdn.microsoft.com/en-IN/library/hh710052.aspx" rel="ugc">https://msdn.microsoft.com/en-IN/library/hh710052.aspx</a><br />
<br />
Hope it helps!!
</div>


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 [https://msdn.microsoft.com/en-IN/library/hh710052.aspx]

Hope it helps!!

<div>
<blockquote>
Azure says the db is about 24 Gig, but the backpac size is 1.5 Gig - is this probable? 
</blockquote>
What's &quot;backpac&quot;? Should be backup?<br />
How are you getting the information about those sizes?
</div>


> 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?

<div>
Ah, ok.<br />
I need to get more into Azure :)<br />
<br />
And it looks like a .bacpac file is a compressed backup so this can justify the size differences (24GB unpacked and 1.5GB packed).
</div>


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).

<div>
<div class="content wysiwyg-content">
I have Database on Azure SQL. I created a backup resulting in a backpac file. <br />
I have two questions:<br />
<br />
1. Azure says the db is about 24 Gig, but the backpac size is 1.5 Gig - is this probable? <br />
<br />
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?
</div>
</div>


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?

SQL Azure Export / Backpac ?

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.