Solved

SQL Azure Export / Backpac ?

Posted on 2016-10-30
4
40 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
  • 2
  • 2
4 Comments
 
LVL 28

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 47

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 28

Accepted Solution

by:
Pawan Kumar earned 500 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 47

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Linked Server Issue with SQL2012 3 26
VBScript Write Column Headers 3 37
Inserting oldest record into new table. 5 23
EA Azure explanation please 3 17
Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
In the market for a new backup solution for Windows Server 2016? Follow these guidelines to get the most bang for your buck.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

770 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