How to deploy dacpac excluding user logins into other environments

Hi Subhomoy, You can create a script (Not in build) for all of the user logins or one script for one user login if you want to control each of them for the deployment. And then you can create a SQLCDM variable, i.e., $(DeployUserLogin) with default value 0. In the user login script, you can add the IF statement:

IF $(DeployUserLogin) = 1 
BEGIN 
	-- User login script is here
END

This way you can control the post deployment scripts for the user logins. If you do not want to deploy them, you can set the variable to 0, otherwise 1.

You'll have to use SqlPackage to deploy the dacpac, see this doc:

https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-publish?source=recommendations&view=sql-server-ver16#properties-specific-to-the-publish-action

Hoping someday Azure Data Studio gets more options around dacpac deployment.

Hi @Subhomoy Chakraborty,

Another approach is to use a pre-deployment script to drop the user logins and roles before deploying the DACPAC, and then create them again after the deployment is complete. You can create a SQL script to drop the logins and roles, and then include it in the "Pre-Deployment Script" section of the DACPAC project properties.

Please refer to this document: https://learn.microsoft.com/en-us/sql/ssdt/how-to-specify-predeployment-or-postdeployment-scripts?view=sql-server-ver16

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".