将本地SQL Server数据库迁移到Azure SQL数据库

In this article, we will discuss and understand a method to migrate an on-premises SQL Server database to the Azure SQL database.

在本文中，我们将讨论和理解将本地SQL Server数据库迁移到Azure SQL数据库的方法。

This article will look at ways to modernize and transform applications and infrastructure by taking advantage of the agility and flexibility of the cloud.

本文将探讨通过利用云的敏捷性和灵活性来现代化和转换应用程序和基础架构的方法。

Azure SQL Database currently resides in ~50 data centers around the world, with more data centers coming online regularly, enabling you to run your database in a data center near you. With so many on-premises implementations at customer sites, how do you migrate from the traditional on-premises SQL Server implementation to modern Azure SQL Database technologies and benefit from what cloud database services can offer?

Azure SQL数据库当前位于全球约50个数据中心中，越来越多的数据中心定期上线，使您可以在附近的数据中心中运行数据库。 在客户站点上有如此众多的本地实施，您如何从传统的本地SQL Server实施迁移到现代Azure SQL数据库技术，并从可提供的云数据库服务中受益？

This article will guide you through the process and steps required to migrate your database workloads from on-premises to Azure-based cloud services.

本文将指导您完成将数据库工作负载从本地迁移到基于Azure的云服务所需的过程和步骤。

介绍 (Introduction)

Digital transformation plays a key role in every organization’s future. Dependencies on legacy systems and siloed processes act as major roadblocks to efforts towards digital transformation.

数字化转型在每个组织的未来中都扮演着关键角色。 对遗留系统和孤立过程的依赖成为实现数字化转型的主要障碍。

For many organizations, the upcoming Microsoft end of support (EOS) for Windows Server and SQL Server 2008 and SQL Server 2008 R2 brings in challenges in terms of innovation, cost, security, and regulatory compliance. Many traditional organizations are under tremendous pressure to upgrade their systems to the more recent versions of Windows and SQL Server.

对于许多组织而言，即将到来的Microsoft对Windows Server和SQL Server 2008和SQL Server 2008 R2的支持终止（EOS）带来了创新，成本，安全性和法规遵从性方面的挑战。 许多传统组织承受着巨大的压力，要求将其系统升级到Windows和SQL Server的最新版本。

If you look at the brighter side, though, this is a great opportunity for organizations to make up for the missed opportunities of the past to migrate, modernize and redefine their core to enhance performance, improve customer experience and drive a competitive edge. One of the options also available is to modernize by migrating their legacy estates to Azure SQL Database.

但是，如果您放眼光明的一面，这对于组织来说是一个很好的机会，可以弥补过去错过的迁移，现代化和重新定义其核心的机会，以增强性能，改善客户体验并提高竞争优势。 还可以使用的选项之一是通过将其旧版资产迁移到Azure SQL数据库来进行现代化。

为什么我们可能必须将本地SQL Server数据库迁移到Azure SQL数据库（PaaS-平台即服务）？ (Why we may have to migrate on-premises SQL Server database to Azure SQL Database (PaaS—Platform as a Service)?)

Microsoft’s enabling functions and cloud offerings have many advantages with Azure SQL Database that runs as a PaaS. On a high level, for instance, there is no need for you to create VMs or install the Windows Server operating system or SQL Server. They are all simply available to use. All you have to do is log into the Azure portal and pick the size and configuration that fits your needs.

Microsoft的支持功能和云产品通过作为PaaS运行的Azure SQL数据库具有许多优势。 例如，在较高级别，不需要创建VM或安装Windows Server操作系统或SQL Server。 它们都可以简单地使用。 您要做的就是登录Azure门户，然后选择适合您需要的大小和配置。

• Note: The PaaS offering from Microsoft provides you with everything required to support database services. Microsoft owns more than half of the administration overhead, which includes patching, software updates, system maintenance, etc. However, it is important to understand the underlying database service implications of this model. Azure SQL Database doesn’t in-house full feature parity when compared to the on-premise database versions of SQL Server like SQL Server 2014, SQL Server 2016, and SQL server 2017

  注意 ：Microsoft的PaaS产品为您提供支持数据库服务所需的一切。 Microsoft拥有一半以上的管理开销，其中包括补丁程序，软件更新，系统维护等。但是，了解此模型对底层数据库服务的意义非常重要。 与SQL Server的本地数据库版本（例如SQL Server 2014，SQL Server 2016和SQL Server 2017）相比，Azure S