Azure SQL数据库Bacpac本地还原 [英] Azure SQL Database Bacpac Local Restore

问题描述

我已经使用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

1. 右键单击连接">数据库" 节点，然后选择"导入数据层应用程序... "
2. 在介绍步骤中选择"下一步".
4. 浏览或连接到保存备份的存储帐户.

1. Right click on the Connection > Databases node and select "Import Data-tier application..."
2. Select "Next" on the introduction step.
4. Browse, or connect to a storage account where backups are kept.

这篇关于Azure SQL数据库Bacpac本地还原的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！