Solved

SQL Azure Export / Backpac ?

Posted on 2016-10-30
4
32 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 18

Expert Comment

by:Pawan Kumar Khowal
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 45

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 18

Accepted Solution

by:
Pawan Kumar Khowal 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 45

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

How does your email signature look on mobiles?

Do your employees use mobile devices to reply to emails? With mobile becoming increasingly important to the business world, it is in your best interest to make sure that your email signature looks great across all types of devices.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
PL/SQL query 14 51
Link SQL table to Webpage 9 39
Access Migration to Sql Server 2 22
In or Between 2 0
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now