question

eitanblumin avatar image
0 Votes"
eitanblumin asked AmeliaGu-msft commented

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

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

sql-server-general
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.


0 Votes 0 ·

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.

1 Vote 1 ·

I agree with Erland.

@AmeliaGu-msft , aren't you a Microsoft employee? Are you certain that the GitHub Issues section for MICROSOFT DOCS 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?

0 Votes 0 ·

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


0 Votes 0 ·

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






0 Votes 0 ·
YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered YitzhakKhabinsky-0887 edited
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered ErlandSommarskog commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·