When you develop web application you often have this scenario. Some people are testers, they are testing the application in dev all day, and they want always to test latest version. Moreover testers usually fills data into web application, so they want their data to be preserved between various deploy. If you simply clear all data in test database you will end with a lot of furious tester so do not even think to do this.
If a developer needs to change database schema, we need to automate not only the deploy of the web application, but we need also to sync test database with the latest changes. This is necessary so the test site can work with the new version, but old data is preserved for the happiness of the testers.
This is quite simple using TFS and Database project. The situation is this one
Three months in and my Visual Studio 2012 is running slow, I’ll even go as far as saying it is freezing up some times, so I loaded up SysInternals Process Monitor and set a filter on Visual Studio and to my complete and utter amazement I found PerfWatson running wild in the system
If you come across publishing a SQL databse from a Visual Studio Database Project that the “the script file could not be found”, after a lot of digging around I found that all you need to do is delete the .dbmdl file, and it will publish again.
In VS 2012 I receive the following error message (one for each table) when trying to build a database project.
SQL71566: Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlFilegroup cannot not be set on both the Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlTable and the clustered Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlPrimaryKeyConstraint.
For reference here is script associated with this error.
How to get StyleCop working and running in Visual Studio 2012
First download the latest StyleCop from Codeplex, and install.
If you now load up Visual Studio and create a new project, how you’ll find lots of underlined code that need attention