Is there a setting that can prevent a column from being added in the middle of a table while developing in Visual Studio's Data-Tier Application (.dacpac) project tools?
I understand that SSMS has a setting similar to the one I'm looking for which was discussed here:
As a previous DBA turned Database Developer, I am learning more each day about the benefits of the scalable database approach using .dacpac deployment. One of the dangers working with Database Projects in Visual Studio seems to be that a user can add a column in the middle of the table, and the project will move data around in the background using temp tables to perform this action. While this may be a great and flexible option for small tables, when working with extremely large tables this can cause problems. As a protective measure, I would like to force developers working on this database project to append columns at the end of the table, rather than be allowed to move columns around and have the project create temp tables and shuffle data around in the background to accommodate the request. I'm curious if this is a setting that can be found at a Solution, Project, or Table level.
Research performed so far:
I've already reviewed the MS data-tier application docs here:
I've watched the Pluralsight video - "DevOps Skills for Developers with Visual Studio and TFS 2017" by Benjamin Day. I've searched the SSC Forums, and done some "right clicking" and searched properties of the Solution and also of the Project (nothing obvious stood out). And lastly I've done the usual Google-Fu looking beyond page 1 to see what if anything can be found.
Thank you in advance to everyone in the community for your time and help!