将SQL数据库迁移到Azure [英] Migrate SQL database to Azure

问题描述

你好

我已经在Azure平台上创建了一个数据库.我想将数据库迁移到Azure.

I have created one database on Azure platform. I wanted to migrate my database to Azure.

我已经创建了表架构，在Azure上存储了Procs.

I already created Tables schema, Stored Procs on Azure. 

由于我的数据格式繁多，因此最快的完成方式是什么.

As my data is in huge format, what is the fastest way to get it done.

我已经使用了MS DMA，但是花了很长时间.

I already used MS DMA but it took long time.

谢谢.

此致

Ajay Dabhade(MCPD，MCTS)

Ajay Dabhade (MCPD, MCTS)

推荐答案

Hello,

您是否尝试过Azure迁移服务?

Have you tried Azure Migration service?

https://docs.microsoft.com/zh-cn/azure/dms/tutorial-sql-server-to-azure-sql

https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql

另一个选项是创建数据库的bacpac，将其上传到Azure存储帐户，然后在Azure门户上使用导入"选项.

Another option is to create a bacpac of your database, upload it to an Azure Storage Account and then use the Import option on Azure Portal.

希望这会有所帮助.

Hope this helps.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

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