Add support for "Prevent saving changes that require table re-creation" option in SqlPackage / SSDT

Eitan Blumin 16 Reputation points MVP

In SQL Server Management Studio, there's a designer option called "Prevent saving changes that require table re-creation".

It would be extremely useful to have a similar option in SqlPackage.exe as well, as it could stop dangerous deployments that could potentially re-create very large tables and severely impact production environments while doing so.

NOTE: This is a re-submission of the Azure feedback item:

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,764 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 21,511 Reputation points
    0 comments No comments

  2. Tom Phillips 17,631 Reputation points

    The way to prevent that is to use "IgnoreColumnOrder" option during deployment or stop adding/removing columns to the middle of tables.

    The ordinal position of columns in SQL Server has no meaning, except when you use SELECT *.