?
Solved

SQL Azure Export / Backpac ?

Posted on 2016-10-30
4
Medium Priority
?
47 Views
Last Modified: 2016-10-31
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?
0
Comment
Question by:Jess31
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 29

Expert Comment

by:Pawan Kumar
ID: 41866366
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
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41866698
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
 
LVL 29

Accepted Solution

by:
Pawan Kumar earned 2000 total points
ID: 41866783
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
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41866816
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

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question