从Linux迁移Azure数据库 [英] Azure database migration from Linux

问题描述

我正在从运行Linux的本地安装中迁移SQL Server数据库.

I am looking to migrate a SQL Server DB from an on-prem installation that is running Linux.

我一直在研究"Azure数据库迁移服务"，但是在本教程中，它使用了仅在Windows上可用的数据库迁移助手".

I've been looking at the 'Azure Database Migration Service' however in the tutorial it uses the 'Database Migration Assistant' which is only available on Windows.

此迁移路径是否使用"Azure数据库迁移服务"?

Is this migration path using the 'Azure Database Migration Service'?

谢谢

亚伦

推荐答案

亚伦卡拉甘，

您有两种选择:

1)您可以将本地数据库导出为.bacpac文件，并将此数据库实例还原到Azure SQL数据库单个实例.您可以通过创建一个Azure SQL Server实例并使用Azure门户中的导入数据库"按钮来完成此操作.

1) You can export the on-premise database as a .bacpac file and restore this db instance to an Azure SQL Database single instance. You can accomplish this by creating an Azure SQL Server instance and use the Import Database button from the Azure Portal.

2)您可以将本地数据库导出为.bak文件，并将其还原到Azure SQL数据库托管实例.您将需要创建一个Azure SQL托管实例逻辑服务器，并使用Azure门户中的导入数据库"按钮.

2) You can export the on-premise database as a .bak file and restore it to an Azure SQL Database Managed Instance. You will need to create an Azure SQL Managed Instance logical server and use the Import Database button from the Azure Portal.

选项1和2类似，但是托管实例部署能够导入.bacpac和.bak数据库文件，其过程如下:

Options 1 and 2 are similar but the Managed Instance deployment is capable of importing both .bacpac and .bak database files, and the process is as follows:

您将需要将.bacpac/.bak文件上传到提供访问Azure门户以读取文件的存储帐户:

You will need to upload the .bacpac/.bak files to a storage account that provides access to the Azure Portal to read the files:

这些选项需要停机才能完成迁移活动.

These options require downtime to complete the migration activity.

这篇关于从Linux迁移Azure数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！