azure - 发布到 Azure 时出错

Question

我正在尝试发布对 Azure 应用服务的一些更改，包括数据库迁移，但我遇到以下错误，是否有人知道这是什么意思。P.S 数据库用户没有分配 sysadmin 服务器角色。

1>Warning SQL0: A project which specifies SQL Server 2016 as the target 
platform may experience compatibility issues with Microsoft Azure SQL 
Database v12.
1>Warning SQL0: Your permissions to see all objects in the server or 
database could not be verified.  The original error was:
1>The SELECT permission has not been granted on 'sys.sql_logins' for the 
'master' database. You must be a member of the 'loginmanager' role to access 
this system view. 
1>Reverse Engineer will continue the import process, and logins will not be 
imported.
1>The reverse engineering operation will attempt to continue anyway, but the 
resulting model might be incomplete, malformed, or incorrect.
1>Error SQL72014: .Net SqlClient Data Provider: Msg 5011, Level 14, State 2, 
Line 5 User does not have permission to alter database 'Iklikl_Staging', the 
database does not exist, or the database is not in a state that allows 
access checks.
1>Error SQL72045: Script execution error.  The executed script:
1>IF EXISTS (SELECT 1
1>           FROM   [sys].[databases]
1>           WHERE  [name] = N'$(DatabaseName)')
1>    BEGIN
1>        ALTER DATABASE [$(DatabaseName)]
1>            SET TEMPORAL_HISTORY_RETENTION ON 
1>            WITH ROLLBACK IMMEDIATE;
1>    END

Answer 1

您需要定位 SQL Azure。

From this article :

更改项目的目标平台

在解决方案资源管理器中右键单击您的项目，然后选择“属性”。单击左侧的“项目设置”选项卡，访问“项目设置”属性页面。

此页面中的目标平台下拉列表包含数据库项目可以发布到的所有受支持的 SQL Server 平台。对于此过程，选择 SQL Azure。