Database management via Visual Studio
Notes from Greg Low's talk at TechEd NZ '09. Visual Studio Team System database edition has merged with developer edition Now called Visual Studio Team System: DB Pro (VSTS:DBPro) - a.k.a. 'DataDude' Released initially as SQL Server 2005 edition 2008 edition of VSTS:DBPro does NOT use SQLS 2008 database GDR release provides SQLS 2008 support GDR2 recently released T-SQL is re-parsed T-SQL parsing dlls can be incorporated into your own apps Should be more extensible in VS2010 Gives great control over database projects Project Management Model based development Team collaboration - TFS, Workitems, Tasks Change Management: SCCI source code management integration Refactoring Schema and data comparison tools Testing Database unit testing MSTest integration Automated data generation system Build/Deploy MSBuild integration Command line tools Allows for multiple inconsistent target systems Build & deploy phases have been separated All important tasks are scriptable Project