CODEWITHSUNDEEP
sql-server-data-tools
Trubs
Trubs

Reputation: 3042

SSDT Project Structure when updating using SchemaCompare

I have set up my sqlproj project structure based on object type using the import Database wizard and using the Object Type as the folder structure. ie the same view as you'd get in SSMS or SQL Server Object Explorer

enter image description here

Yet when using ssdt schema compare to update the project, objects are always imported into Schema\Object Type structure, causing the project to turn into a mess of mixed structure.

I cant find anywhere I can change the behaviour of the Schema Compare update to continue to use the Object Type structure?

using ssdt 14.0.51215 (Dec 2015)

Upvotes: 1

Views: 770

Answers (2)

tariq
tariq

Reputation: 51

you'll have to update the sqlproj file directly... 

  <PropertyGroup>
...

    <DefaultFileStructure>BySchemaType</DefaultFileStructure>
...

  </PropertyGroup>

More info on this link... https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e6bfd561-3e7d-4052-be9c-631037681c3e/default-file-structure?forum=ssdt

Upvotes: 0

Steven Green
Steven Green

Reputation: 3517

I would suggest submitting this feedback as a suggested improvement to Microsoft at https://connect.microsoft.com/SQLServer/feedback/CreateFeedback.aspx using the category "Developer Tools (SSDT, BIDS, etc.)"

Upvotes: 1

Related Questions