sql-server - Azure SQL 数据库 : bacpac Import Error occurs on azure portal

Question

我已从本地导出数据层应用程序，并尝试从新数据库上的 Azure 门户导入。但它一直失败，我不确定以下错误消息是否被截断，但我觉得它丢失了一些东西。任何帮助表示赞赏。将 .bacpac 导入到 Azure SQL 时会发生这种情况。

   {
  "code": "DeploymentFailed",
  "message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.",
  "details": [
    {
      "code": "BadRequest",
      "message": "The ImportExport operation with Request Id '3d73223b-acff-4c6e-a981-39d27234d89d' failed due to 'Could not import package.\nWarning SQL0: A project which specifies SQL Server 2016 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.\nWarning SQL72012: The object [data_0] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.\nWarning SQL72012: The object [log] exists in the target, but it will not be dropped even though you '."
    }
  ]
}

Answer 1

使用Data Migration Assistant将数据迁移到 Azure SQL。它将首先评估数据库以确保其兼容。然后它将指导您完成迁移过程 - 它还会告诉您如果出现一些兼容性问题该怎么办。