Azure SQL数据库Bacpac本地还原
问题描述：
我已经使用Azure管理控制台中的导出"选项创建了我的Azure SQL数据库的BACPAC备份.
I've created a BACPAC backup of my Azure SQL Database using the "Export" option within the Azure Management Console.
已将其下载到我的计算机上，我对如何将其还原到本地SQL Server实例有些困惑.我遇到了DacImportExportCli工具，但找不到本地还原的示例.
Having downloaded this to my machine I'm a little stuck on how I can restore this to a local SQL Server instance. I came across the DacImportExportCli tool but couldn't find an example of a local restore.
此外，如果有人编写了执行此操作的脚本(这样就可以安排它了)，那就太棒了.
Also if anyone has written a script that does this (so it can be scheduled) that would be awesome.
答
这可以简单地通过SQL Server Management Studio 2012完成
This can be done simply through SQL Server Management Studio 2012
- 右键单击连接">数据库" 节点，然后选择"导入数据层应用程序... "
- 在介绍步骤中选择"下一步".
- 浏览或连接到保存备份的存储帐户.
- Right click on the Connection > Databases node and select "Import Data-tier application..."
- Select "Next" on the introduction step.
- Browse, or connect to a storage account where backups are kept.