blocks|key|880379|text|Azure+SQL数据库目前不支持该功能。在Azure中还原的唯一方法是从BACPAC文件中导入-您可以使用BACPAC文件迁移到Azure，方法是遵循以下指南：https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|880380|其他选项是使用VM中的Server，这将启用.bak文件的还原。|880381|entityMap|0|LINK|mutability|MUTABLE|url|https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/|1|https://azure.microsoft.com/en-us/pricing/details/virtual-machines/#Sql^0|29|2C|0|0|7|A|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Azure SQL Database does not currently support that functionality. The only method to restore in Azure SQL Database is import from BACPAC files - you can migrate to Azure SQL DB using BACPAC files by following this guide: <a href="https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/" rel="noreferrer">https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/</a>

The other options is to use <a href="https://azure.microsoft.com/en-us/pricing/details/virtual-machines/#Sql" rel="noreferrer">SQL Server in a VM</a>, which would enable a restore of a .bak file

blocks|key|2040880|text|如果您已经在本地机器上有一个数据库，那么可以使用在Azure上直接迁移它。遵循以下步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2040881|右键单击SSMS中的数据库名称：|2040882|📷|atomic|offset|length|2040883|​|2040884|跟随出现的向导。|2040885|如果您正在运行SSMS+v17，您可以配置Azure数据库版本、大小和服务目标。|2040886|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/3c82ec5c57705ac0ca783275b369b796.png|imageAlt^0|0|0|0|1|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Z|8|@]|9|@$G|10|H|11|1|12]]|A|$]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V|W|-4]]]]

If you already have a database on local machine then you can migrate it directly on Azure using SQL Management Studio. Follow these steps:

Right click on the database name in SSMS:
<a href="https://i.stack.imgur.com/33UaW.png" rel="noreferrer"><img src="https://i.stack.imgur.com/33UaW.png" alt="mssms"></a>

Follow the wizard that appears then.

If you're running SSMS v17 you can configure the Azure SQL database edition, size and service objective.

blocks|key|2041012|text|目前，Azure不支持使用备份(.bak)文件在Azure实例上还原数据库。但是，还有许多其他方法可以将SQL数据库迁移到Azure+SQL。例如，使用，或者在.bacpac文件中获取备份，然后使用SSMS导出/导入或使用Microsoft数据库迁移辅助工具导入备份。下面的链接将对您有用，因为他们解释这些方式作为一步一步。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2041013|如何使用SSMS导出/导入将SQL数据库迁移到Azure+SQL数据库|unordered-list-item|offset|length|2041014|如何使用SSMS部署将SQL数据库迁移到Azure+SQL数据库|2041015|使用Microsoft数据库迁移助手(DMA)工具将SQL数据库迁移到Azure+SQL实例|2041016|entityMap|0|LINK|mutability|MUTABLE|url|http://www.techmixing.com/2018/11/how-to-migrate-sql-database-to-azure-sql-database-using-ssms-export-import.html|1|http://www.techmixing.com/2018/11/how-to-migrate-sql-database-to-azure-sql-database-using-ssms-deploy.html|2|http://www.techmixing.com/2018/11/migrating-sql-database-to-azure-sql-instance-using-microsoft-database-migration-assistant-dma-tool.html^0|0|0|Z|0|0|0|W|1|0|0|1A|2|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@$E|Y|F|Z|1|10]]|A|$]]|$1|G|3|H|5|D|7|11|8|@]|9|@$E|12|F|13|1|14]]|A|$]]|$1|I|3|J|5|D|7|15|8|@]|9|@$E|16|F|17|1|18]]|A|$]]|$1|K|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]|S|$5|N|O|P|A|$Q|T]]|U|$5|N|O|P|A|$Q|V]]]]

Currently Azure doesn't support restoring the database on Azure SQL Instance using the backup (.bak) file. But there are many other ways to migrate the SQL Database to Azure SQL. For example, using the SQL Server Management Studio deploy mention or by taking the backup in the .bacpac file and then importing it using SSMS Export/Import or using the Microsoft database migration assistance tool. Below link will be useful to you as they explain these ways as step by step process.
<ul>
<li><a href="http://www.techmixing.com/2018/11/how-to-migrate-sql-database-to-azure-sql-database-using-ssms-export-import.html" rel="nofollow noreferrer">How to migrate SQL Database to Azure SQL Database using SSMS Export/Import</a>
</li>
<li><a href="http://www.techmixing.com/2018/11/how-to-migrate-sql-database-to-azure-sql-database-using-ssms-deploy.html" rel="nofollow noreferrer">How to migrate SQL Database to Azure SQL Database using SSMS deploy</a>
</li>
<li><a href="http://www.techmixing.com/2018/11/migrating-sql-database-to-azure-sql-instance-using-microsoft-database-migration-assistant-dma-tool.html" rel="nofollow noreferrer">Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool</a>
</li>
</ul>

blocks|key|2041180|text|为了在上获得我的.BAK文件，我遵循了这个线程中两个答案的建议。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2041181|在完成以下步骤之前，BAK文件还原在我的笔记本SQL实例上失败(备份来自SQL2016，与我的SQL2014不兼容)。我正在进行https://aka.ms/edx-dat216x-about的培训，我从培训中下载了这两个文件：AdventureWorks2016CTP3.bak和AdventureWorksDW2016CTP3.bak。|offset|length|style|CODE|2041182|BAK到AzureDB|2041183|blockquote|2041184|用户：Joseph+/答案：在VM中使用Server，这将启用.bak文件的恢复|ordered-list-item|BOLD|2041185|我遵循这2段视频(托管在YouTube上)来创建Azure+VM和SQL+Instance，用于MCA培训…https://youtu.be/YZ5yWAjV7IM。9:00分钟的视频展示了如何提供相关的Azure资源。该视频还演示了如何获取Azure+SQL数据库的连接字符串，该连接字符串将在下一步中使用。|2041186|从Azure远程会话连接到SSMS，我从BAK执行了还原数据库。|2041187|用户：razon+x答案：右键单击(数据库名称)>任务>部署数据库到SQL…|2041188|从Azure远程会话连接到SSMS实例，我运行向导“Database”。连接成功后，部署需要几分钟才能完成。注意:您必须使用“Server身份验证”，因为Azure数据库不支持“Windows”。Azure+SQL+Server身份验证在本答案前面提供的视频链接中进行了演示。|2041189|部署环境|2041190|@@servername+@@version|2041191|%2B------------------------------------------------------------------------------------------------------%2B
%7C+Source+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%2B------------------------------------------------------------------------------------------------------%2B
%7C+data216x+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C+Microsoft+SQL+Server+2016+(SP1-CU13)+(KB4475775)+-+13.0.4550.1+(X64)+++++++++++++++++++++++++++++++++%7C
%7C+Jan+10+2019+19:31:11+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C+Copyright+(c)+Microsoft+Corporation++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C+Developer+Edition+(64-bit)+on+Windows+Server+2016+Datacenter+10.0+<X64>+(Build+14393:+)+(Hypervisor)+%7C
%2B------------------------------------------------------------------------------------------------------%2B
%7C+Target+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%2B------------------------------------------------------------------------------------------------------%2B
%7C+sqlserver-dat216x++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C+Microsoft+SQL+Azure+(RTM)+-+12.0.2000.8++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C+Dec+19+2018+08:43:17+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%7C+Copyright+(C)+2018+Microsoft+Corporation+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%7C
%2B------------------------------------------------------------------------------------------------------%2B|code-block|syntax|javascript|2041192|结果|2041193|在带有此消息的步骤上的步骤Importing+database中，“将数据库部署到Azure”在我的场景中失败。在我删除了不兼容的对象之后，Azure+DB部署就成功了。|2041194|导入数据库..。|2041195|标题：
无法导入包。
警告SQL0:将Server+2016指定为目标平台的项目可能会遇到与MicrosoftAzureSQLDatabasev12的兼容性问题。
错误SQL72014：.Net+SqlClient数据提供程序:+Msg+40536，级别16，状态2，行1
数据库的这个服务层不支持'MEMORY_OPTIMIZED表‘。有关Windows数据库的不同服务层中的功能支持的详细信息，请参阅联机丛书。
错误SQL72045:脚本执行错误。已执行的脚本：
创建类型为Sales.SalesOrderDetailType_inmem的表(+OrderQty+SMALLINT、ProductID+INT+NULL、SpecialOfferID+INT+NULL、IX_SpecialOfferID+NONCLUSTERED+HASH+(SpecialOfferID)+WITH+(BUCKET_COUNT+=+8)、BUCKET_COUNT+IX_ProductID+NONCLUSTERED+HASH+(ProductID)+WITH+(BUCKET_COUNT+=+8))和(MEMORY_OPTIMIZED+=+ON)；
(Microsoft.SqlServer.Dac)
纽扣：
好的|2041196|截图：|2041197|在我删除了不兼容的对象之后，Azure+DB部署就成功了。(注:我不得不这样做几次。我尝试了Redgate+SQLSearch的MEMORY_OPTIMIZED，但是它一直说“没有搜索结果”，尽管表定义中确实包含了关键字。)|2041198|​|2041199|📷|atomic|2041200|2041201|entityMap|0|LINK|mutability|MUTABLE|url|https://aka.ms/edx-dat216x-about|1|https://youtu.be/YZ5yWAjV7IM|2|IMAGE|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/a4b2831b8e9d43d673fa3d60dd6617af.png|imageAlt^0|0|36|Q|3X|S|1S|W|0|0|0|0|0|2|B|2|0|O|8|X|C|1I|S|1|0|0|0|2|A|2|0|P|A|0|0|4|0|0|0|0|D|I|0|0|0|0|1S|G|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|24|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|25|8|@$D|26|E|27|F|G]|$D|28|E|29|F|G]]|9|@$D|2A|E|2B|1|2C]]|A|$]]|$1|H|3|I|5|6|7|2D|8|@]|9|@]|A|$]]|$1|J|3|-4|5|K|7|2E|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|2F|8|@$D|2G|E|2H|F|O]|$D|2I|E|2J|F|O]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|2K|8|@$D|2L|E|2M|F|G]|$D|2N|E|2O|F|G]]|9|@$D|2P|E|2Q|1|2R]]|A|$]]|$1|R|3|S|5|6|7|2S|8|@]|9|@]|A|$]]|$1|T|3|U|5|N|7|2T|8|@$D|2U|E|2V|F|O]|$D|2W|E|2X|F|O]]|9|@]|A|$]]|$1|V|3|W|5|6|7|2Y|8|@$D|2Z|E|30|F|O]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|31|8|@$D|32|E|33|F|O]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|34|8|@]|9|@]|A|$]]|$1|11|3|12|5|13|7|35|8|@]|9|@]|A|$14|15]]|$1|16|3|17|5|6|7|36|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|37|8|@$D|38|E|39|F|G]]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|3A|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|K|7|3B|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|6|7|3C|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|3D|8|@$D|3E|E|3F|F|G]]|9|@]|A|$]]|$1|1I|3|1J|5|6|7|3G|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|1M|7|3H|8|@]|9|@$D|3I|E|3J|1|3K]]|A|$]]|$1|1N|3|1J|5|6|7|3L|8|@]|9|@]|A|$]]|$1|1O|3|-4|5|6|7|3M|8|@]|9|@]|A|$]]]|1P|$1Q|$5|1R|1S|1T|A|$1U|1V]]|1W|$5|1R|1S|1T|A|$1U|1X]]|1Y|$5|1Z|1S|20|A|$21|22|23|-4]]]]

To get my .BAK file on Azure SQL Server, I followed the advice of both answers in this thread. 

Before completing the below steps the BAK file restore failed on my laptop SQL instance (the backups were from SQL2016 and not compatible with my SQL2014). I was working on training from <a href="https://aka.ms/edx-dat216x-about" rel="nofollow noreferrer">EDX.org: “DAT216x Delivering a Relational Data Warehouse”</a> and I had downloaded these two files from the training: <code>AdventureWorks2016CTP3.bak</code> and <code>AdventureWorksDW2016CTP3.bak</code>.

<h2>BAK to AzureDB</h2>

<blockquote>
 <ol>
 <li>USER: Joseph Idziorek | ANSWER: Use SQL Server in a VM, which would enable a restore of a .bak file</li>
 </ol>
 
 I followed these 2 videos (hosted on YouTube) to create the <code>Azure VM</code> and <code>SQL Instance</code> to be used in MCA training… <a href="https://youtu.be/YZ5yWAjV7IM" rel="nofollow noreferrer">Demo: Provisioning Microsoft Azure Services (VM, SQL)</a>. The 9:00-minute video shows you how to provision the relevant Azure resources. The video also demonstrates how to get the connection string for the Azure SQL Database, which is used in the next step. 
 
 From the Azure VM remote session connection to SSMS I did the Restore Database from BAK.
 
 <ol start="2">
 <li>USER: razon | ANSWER: Right click (database name) > Tasks > Deploy Database to SQL Azure…</li>
 </ol>
 
 From the Azure VM remote sessions connection to SSMS SQL Instance, I ran the wizard “Deploy Database to SQL Azure”. After connection successfully the deployment took a few minutes to complete. NOTE: you must use ‘SQL Server Authentication’ because ‘Windows’ is not supported for Azure database. The Azure SQL Server authentication was demonstrated in the video link provided earlier in this answer. 
</blockquote>

Deployment environments

@@servername @@version

<pre><code>+------------------------------------------------------------------------------------------------------+
| Source |
+------------------------------------------------------------------------------------------------------+
| data216x |
| |
| Microsoft SQL Server 2016 (SP1-CU13) (KB4475775) - 13.0.4550.1 (X64) |
| Jan 10 2019 19:31:11 |
| Copyright (c) Microsoft Corporation |
| Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 &lt;X64&gt; (Build 14393: ) (Hypervisor) |
+------------------------------------------------------------------------------------------------------+
| Target |
+------------------------------------------------------------------------------------------------------+
| sqlserver-dat216x |
| |
| |
| Microsoft SQL Azure (RTM) - 12.0.2000.8 |
| Dec 19 2018 08:43:17 |
| Copyright (C) 2018 Microsoft Corporation |
+------------------------------------------------------------------------------------------------------+
</code></pre>

<h2>Results</h2>

The Deploy Database to Azure failed in my scenario on the step <code>Importing database</code> with this message. After I removed the incompatible objects the Azure DB deployment was successful. 

Importing database...

<blockquote>
 TITLE: Microsoft SQL Server Management Studio
 
 Could not import package.
 
 Warning SQL0: A project which specifies SQL Server 2016 as the target
 platform may experience compatibility issues with Microsoft Azure SQL
 Database v12.
 
 Error SQL72014: .Net SqlClient Data Provider: Msg 40536, Level 16,
 State 2, Line 1 
 
 'MEMORY_OPTIMIZED tables' is not supported in this service tier of the
 database. See Books Online for more details on feature support in
 different service tiers of Windows Azure SQL Database.
 
 Error SQL72045: Script execution error. The executed script:

<pre><code>CREATE TYPE [Sales].[SalesOrderDetailType_inmem] AS TABLE (
 [OrderQty] SMALLINT NOT NULL,
 [ProductID] INT NOT NULL,
 [SpecialOfferID] INT NOT NULL,
 INDEX [IX_SpecialOfferID] NONCLUSTERED HASH ([SpecialOfferID]) WITH (BUCKET_COUNT = 8),
 INDEX [IX_ProductID] NONCLUSTERED HASH ([ProductID]) WITH (BUCKET_COUNT = 8))
 WITH (MEMORY_OPTIMIZED = ON);
</code></pre>
 
 (Microsoft.SqlServer.Dac)
 
 BUTTONS:
 
 OK
</blockquote>

Screenshot:

After I removed the incompatible object the Azure DB deployment was successful. (NOTE: I had to do this a couple times. I tried Redgate SQLSearch for <code>MEMORY_OPTIMIZED</code> but it kept saying "no search results" even though the table definition did include the keyword.) 

<a href="https://i.stack.imgur.com/gfJc9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gfJc9.png" alt="enter image description here"></a>

blocks|key|880626|text|尝试“数据迁移助手”；https://learn.microsoft.com/en-us/sql/dma/dma-migrateonpremsqltosqldb?view=sql-server-ver15|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|880627|DMA下载：https://www.microsoft.com/en-us/download/confirmation.aspx?id=53595|880628|entityMap|0|LINK|mutability|MUTABLE|url|https://learn.microsoft.com/en-us/sql/dma/dma-migrateonpremsqltosqldb?view=sql-server-ver15|1|https://www.microsoft.com/en-us/download/confirmation.aspx?id=53595^0|B|2J|0|0|6|1V|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Try the &quot;Data Migration Assistant&quot;;
<a href="https://learn.microsoft.com/en-us/sql/dma/dma-migrateonpremsqltosqldb?view=sql-server-ver15" rel="nofollow noreferrer">https://learn.microsoft.com/en-us/sql/dma/dma-migrateonpremsqltosqldb?view=sql-server-ver15</a>
DMA Download :
<a href="https://www.microsoft.com/en-us/download/confirmation.aspx?id=53595" rel="nofollow noreferrer">https://www.microsoft.com/en-us/download/confirmation.aspx?id=53595</a>

Is there a way to simply take a SQL backup .bak file, and using that as a restore point to generate a new database on Azure SQL Database? 

The wizard that I see generally recommended in this situation wants to create a custom file to use, but it pukes on the encrypted objects ( functions and views ) and I don't see another way to get it going.

Restoring SQL Server backup to Azure SQL Database

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

有没有一种方法可以简单地获取一个SQL备份.bak文件，并使用它作为恢复点在上生成一个新的数据库？在这种情况下，我通常推荐的向导希望创建一个要使用的自定义文件，但是它会吐出加密的对象(函数和视图)，我看不出有其他方法可以实现它。

问将Server备份还原到Azure SQL数据库
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将Server备份还原到Azure SQL数据库EN