英文:
SQL DB migration to Azure SQL using Azure Data Studio
问题
I am not able to migrate on-premise SQL Server database to an Azure SQL database.
我无法将本地 SQL Server 数据库迁移到 Azure SQL 数据库。
I am using Azure Data Studio while doing the migration. I am not able to "Select the tables" at the end, due to which I am not able to proceed next.
在进行迁移时,我正在使用 Azure Data Studio。在最后无法“选择表格”,因此无法继续进行。
英文:
I am not able to migrate on-premise SQL Server database to an Azure SQL database.
I am using Azure Data Studio while doing the migration. I am not able to "Select the tables" at the end, due to which I am not able to proceed next.
答案1
得分: 1
请尝试使用Azure数据迁移助手(DMA)而不是。您可以从这里下载它。首先执行评估,您可能需要在迁移到Azure SQL之前修复一些不兼容性。一旦不兼容性问题解决了,可以按照这里所述使用DMA进行迁移。
英文:
Please try to use Azure Data Migration Assistant (DMA) instead. You can download it from here. Perform an assessment first, you may need to fix some incompatibilities before migrating to Azure SQL. Once the incompatibilities have been fixed, try to migrate using DMA as explained here.
答案2
得分: 1
如果您只想迁移数据库而不包括数据,请使用 .dacpac。
如果您希望将数据一同迁移,请生成一个 bacpac 并导入它。
然而,从本地迁移到 Azure SQL 数据库的最佳和最可靠方法是使用数据迁移助手。它将允许您在迁移之前进行预评估,列出任何兼容性问题。您可以解决这些问题并使用此实用程序进行迁移。
英文:
if you want to migrate only the db without data, use .dacpac
if you want to migrate with data generate a bacpac and import it.
However the best and most reliable method for a migration from on premise to azure sql db would be to use Data migration assistant. It will allow you to do a pre assessment before the migration to list any compatibility issues. You can fix the issues and do a migration using this utility.
答案3
得分: 0
"确保在选择要迁移的表列表之前,使用SQL Server dacpac扩展或Azure Data Studio中的SQL数据库项目扩展,将数据库模式从源迁移到目标。"
你这样做了吗?
英文:
"Make sure to migrate the database schema from source to target by using the SQL Server dacpac extension or the SQL Database Projects extension in Azure Data Studio before selecting the list of tables to migrate."
Did you do this?
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论