I used to create my application database by managing a series of install scripts with one table or stored procedure per file. In those files I had to manage potential changes to those schema items and also handle conditional creation of those entities if they did not exist. SQL Server Data Tools built into Visual Studio 2012 has made this into a much simpler process. A version of this existed in Visual Studio 2010, but it is even better in Visual Studio 2012.
View original post 1,678 more words