visual studio 2012 - Data Tools Database Project: Automatically Create Nice Folder Structure -
When I import a DACCPAC in the VAS SSDT project, it creates a very good folder structure for me: my All schemas are defined under a folder named "Security" and then each schema has its own name folder, which contains folders named "Tables", "Collected Process", etc. However, if I right-click on the project name and select Add> Table, the new table has just been added to the project's root. It does not look right at all. Is there any way to get VS to respect the file structure I created when importing a DACCPAC?
I have found that the best way to deal with this is to VS. Side changes are not making, but rather to make SQL Server-side changes. After making changes in DB in question, I compare a schema against the actual DB on SQL Server, and VS Project. When I update against the difference, then maintains good structure.
Comments
Post a Comment