Sqlpackage Publish Error: If this deployment is executed, [unnamed] will be dropped and not re-created

  • (Note that 'unnamed' appears in angled brackets in the error text)

    Has anyone seen the above error while deploying a database from SSDT?
    It's particularly difficult to troubleshoot for a couple of reasons:
    1) <unnamed> doesn't give a lot of clues as to what the problem is, and
    2) I cannot even create a publish preview to analyse the script.

    I am publishing from a database project to a SQL Server 2016 database, using sqlpackage with the following qualifiers:

    /p:ScriptDatabaseOptions=False /p:DropObjectsNotInSource=True /p:DoNotDropObjectTypes=RoleMembership;Users;Permissions

    --Edit: When people put code in a code block, it would probably be better not to interpret emoticons from within that code.


  • Did you have a solution for this?

  • ashwath.cr - Thursday, November 29, 2018 12:14 PM

    Did you have a solution for this?

    I guess I did, as I am (thankfully) no longer stuck on the problem 🙂

    But as to the details, I'm afraid my memory isn't that good ... sorry. I wish I'd recorded the solution here.


Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply