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

Eitan Blumin 16 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:
https://feedback.azure.com/forums/908035-sql-server/suggestions/43852278-add-support-for-prevent-saving-changes-that-requi

AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor

2021-09-06T05:37:15.847+00:00

Hi eitanblumin,

You can submit this feedback to this link https://github.com/MicrosoftDocs/sql-docs/issues.
Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding

Best Regards,
Amelia

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Erland Sommarskog 100.8K Reputation points MVP

2021-09-06T20:56:08.497+00:00

As far as I know that site is solely for submitting issues about the documentation about SQL Server. It is not about features. Please do not suggest that people should submit non-doc issues to this site.
Eitan Blumin 16 Reputation points MVP

2021-09-07T08:02:16.387+00:00

I agree with Erland.

@AmeliaGu-MSFT , aren't you a Microsoft employee? Are you certain that the GitHub Issues section for Microsoft Learn is the place to submit feedback items for SQL Server tooling?

I mean, sure GitHub issues is great and all. But isn't this a very problematic slippery road you're directing us to?
Shouldn't there be some kind of separation between different Microsoft products when submitting and looking for feedback items?
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor

2021-09-08T06:29:39.86+00:00

Hi eitanblumin,

Thanks for your reply.
Please see SQL Server help and feedback. I’m afraid there is no feedback site specifically for SQL Server issues yet, and we have to wait for related announcements. Sorry for any inconvenience.

Best Regards,
Amelia
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor

2021-09-22T02:03:35.583+00:00
Hi eitanblumin,
Right now UserVoice(feedback.azure.com) has been decommissioned and its replacement will be online in mid-October 2021.
If you have any wish to make feedback requests about SQL Server in the meantime, please provide us all the information listed below and we are glad to submit it on behalf of you.

Title:

Technical Feedback(Describe the precise feedback. Please avoid entering PII(Personally Identifiable Information)):

Business Scenario and Desired Outcome:

Issue Impact:

Workaround details if there are any:

Please be sure to explain things as much as possible, thanks for your patience.

Best Regards,
Amelia

2 answers

Yitzhak Khabinsky 24,936 Reputation points

2021-09-05T13:54:07.643+00:00

Hi @Eitan Blumin ,

Unfortunately, the Azure feedback is in a RIP state now.

Please chime in here: https://learn.microsoft.com/en-us/answers/questions/520845/where-does-one-report-sql-server-or-t-sql-bugs-now.html?childToView=521162#answer-521162
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Tom Phillips 17,716 Reputation points

2021-09-08T12:57:19.873+00:00

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 *.
Please sign in to rate this answer.
Erland Sommarskog 100.8K Reputation points MVP

2021-09-08T20:51:23.827+00:00

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

Hrmpf! If you want to understand a table, do you like to get the documentation of the column in random order?

Or for that matter when doing SELECT * on a 80-column table, do you want jump forth and back because related columns are twenty columns apart?

Column order matters a lot to human, and it is a shame that there is not ALTER TABLE that permits you and column at a given position in a table to reshuffle them.
Sign in to comment