将SQL Server数据库迁移到Azure SQL数据库 [英] migrate sql server database to azure sql database
问题描述
我们在vm上有一个sql服务器,还有一个Azure sql数据库,现在我们想将vm db迁移/恢复到Azure db.我知道如何通过ssms手动进行操作.但是我们要计划它,因为我们需要每天运行它.我找不到T-SQL脚本来执行这些操作. 有什么办法?
We have a sql server on vm, and a azure sql database, now we want to migrate/restore the vm db to the azure db. I know how to do that via ssms manually. But we want to schedule it because we need to run it daily. I can't find the t-sql scripts to do these. Is there any way?
推荐答案
您是否考虑过使用Azure SQL数据同步?
Have you considered using Azure SQL Data Sync?
更多信息,请访问 https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-sync-data 和 https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-get-started-sql-data-sync
More at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-sync-data and https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync
hth
Marcin
这篇关于将SQL Server数据库迁移到Azure SQL数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!