Missing the option of creating table dependent objects within separate files
I have been developing database for over 12 years for use with applications and business intelligence projects. One of the challenges I used to face was how to put the SQL Server database under source control. Over the years I came across several methods: Direct Database development with nightly backup, Script(s) place under source control, SSMS Projects. Microsoft help to solved the problem when they release Visual Studio Data Database Professional (DataDude), when Visual Studio 2005 was around, which add a project structure, development methods, build and deployment methods. Recently Microsoft has release a new replacement database development tool: SQL Server Data Tools, which has some improvements and some missing features. One of the missing features is the folder structure choice that which I talk about in another post : http://zogamorph.blogspot.co.uk/2012/06/how-to-create-old-database-project.html . Another change is the dropping of the development method of one obje