Jess31
asked on
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?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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).
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).
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!!