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

  • Phil Parkin

    SSC Guru

    Points: 243477

    (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.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • ashwath.cr

    Newbie

    Points: 7

    Did you have a solution for this?

  • Phil Parkin

    SSC Guru

    Points: 243477

    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.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

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

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