Post reply

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

  • February 15, 2017 at 11:36 am

    #321676

    (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 you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • November 29, 2018 at 12:14 pm

    #2014994

    Did you have a solution for this?

  • November 29, 2018 at 12:26 pm

    #2014995

    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 you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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