Ok, I’m a fan of having the database in some form of source control, thus I’ve been using Visual Studio to help develop databases for a number of years now. I also know that there are vast arguments for either side of the fence but that’s for another post. Regardless, I keep my databases contained in source control and currently use a combination of Management Studio and Visual Studio 2010 (not going to 2012 just yet) to design/create/maintain my databases.