update database using Sql Server data tool RRS feed

  • Question

  • Environment: Visual Studio 2017, Windows 10, SQL Server 2014


    I am using SqlPackage.exe to upgrade a database. Database has two type of tables: user tables and application tables.

    Application table is use by my developed application. User tabled is created user. During SQL package upgrade only application tabled should be deleted in target database after specifying command

    /p: DropObjectsNotInSource=true

    But SqlPackage.exe also deletes the user table.

    Please suggest how I can bypass deletion of user table.

    Thanks in advance,


    Monday, November 4, 2019 8:35 AM

All replies

  • I would suggest to set DropObjectsNotInSource to false and to create a post deployment script to check if the application tables on the destination database are on the list of the tables from your SSDT. If not, drop them.

    A Fan of SSIS, SSRS and SSAS

    Monday, November 4, 2019 3:32 PM