Dacpac publish how to ignore create database statement?

Question

Due to shared database, we don't have admin privs. Only we have schema id. In dacpac build or sqlpackage.exe publish is there anyway to ignore the Create database statement ?

2020-03-23T21:48:54.5875811Z ##[error]*** Could not deploy package. 2020-03-23T21:48:54.5930784Z ##[error]Error SQL72014: .Net SqlClient Data Provider: Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'master'. Error SQL72045: Script execution error. The executed script: CREATE DATABASE [$(Datab 2020-03-23T21:48:54.6200608Z ##[error]aseName)] COLLATE SQL_Latin1_General_CP1_CI_AS

i tried with below option in sqlpackage.exe and it's not working

/p:CreateNewDatabase=False /p:ExcludeObjectTypes=Users;Logins;RoleMembership;Permissions;Credentials;DatabaseScopedCredentials

is it possible to hack the dacpac sql script comment the create database and from next version it should able to skip because of incremental load? Appreciate your idea.

For Azure sql datawarehouse is there any alternative to DACPAC deployment ?

Shamrai Aleksander Shamrai Aleksander · Accepted Answer · 2020-03-25T11:39:52

You can use sqlpackage.exe to generate update scripts (/a:Script) between your dacpac and target database. Then you can remove unneeded instruction. Here is example to create pipeline: Azure Pipelines - Generating DB Script with SqlPackage.exe

Dacpac publish how to ignore create database statement?

1 Answers