Visual Studio the only tool for the database

Visual Studio the only tool for the database developer? L. (Van) Van Lowe Twitter: lvanlowe Email: van@nuttin-but. net Web: www. nuttin-but. net

Introductions It always helps to know who you’re dealing with, so here’s a little background on me. Independent Consultant since 1996 Federal agency 10 years Enterprise (LOB) Developer since 1979 Computer Science MS Asp. Net Developer since 2003 MCSD fortune 100 company 15+ years Volunteer Developer Prince William Special Olympics

Objective To show to do database developer functions without SSMS (or just using VS)

Assumptions You know what a database is? You know what a table is? You know what a view is? You know what a store proc is? You know what a UDF is? You know something about Visual Studio?

Resources Data Developers Center http: //msdn. microsoft. com/en-us/data/tools. aspx SQL Server Data Tools Documentation http: //msdn. microsoft. com/enus/library/hh 272686(v=vs. 103). aspx SQL Server Data Tools Team Blog http: //blogs. msdn. com/b/ssdt/

Agenda What are we going to talk about today? History of Visual Studio Data Tools Working with data base connected Working with database offline Database Unit Testing

History Visual Studio 2008 Database Edition (Data Dude) Database project type SSDT code name “Juneau” November 2010 4 CTP’s Released Visual Studio 2010 & 2012 March 2012 Dacpac (Database Snapshots Sql Server 2008 R 2)

Demo Tables Views Store Procs UDFs Schema Compares Database snapshoots Unit Testing

Demo