This Article is about how to restore your Azure database to your local SQL or SQL express Database since it may be difficult for some customers to handle this. Then , you can take .bak/.mdf backup file from local and then restore to your SQL database on our server. So install SQL server or SQL express on your computer at first is necessary.
Part one : Backup your SQL Azure database. The Backup file should be .bacpac file.
You can refer to the Most detail steps:
Some people prefer to use the Azure Management Portal. Export the .bacpac file and download to your local computer.
Someone generally Export the .bacpac to blob storage and download it to their local. it’s not the best method but it’s one.
Part Two: Restoring BACPAC with Microsoft SQL Management Tools
As I mentioned, there’s a small catch – you need the Microsoft SQL Management Tools from SQL 2012. You simple need a release version (not the release candidate) of the Management Tools, even the Express edition works fine. Simply download from the official site.
Right click on Databases and click Import Data-tier Application. it looks unusual but just roll with it.
Follow the instructions.
Select the path to your downloaded BACPAC file.
Give the database you’re restoring a name and define a location for the data and log files.
Review the summary and ensure all your details are correct.
Then it will need to take a few minutes for import, that depend on how large your files is.
After it completed, you can check the new DB.
Till now, your Azure database get restore to your local SQL server.We have the most detail steps for backup your local MSSQL db and restore to our server. You can refer to :
Article ID: 1923, Created: January 13, 2017 at 2:15 AM, Modified: January 7, 2022 at 4:11 AM