Using SSDT (SQL Server Data Tools) to Manage Database Lifecycle

Talk at DevLink 2013
This session will concentrate on features of SSDT as it pertains to creating and updating data structure while incorporating your databases into source control management as well as full application lifecycle management. Discussion will include structure management, seeded data management and deployment. Build integration features will also be part of the talk. Learning objectives 1. Core features of SSDT 2. Source control and artifacts creation 3. Refactoring and build integration

Transcript

1. USING SSDT (SQL SERVER DATA TOOLS) TO MANAGE DATABASE LIFECYCLE SERGEY BARSKIY ARCHITECT, TYLER TECHNOLOGIES MICROSOFT MVP
2. PROBLEMS WITH DATABASE DEVELOPMENT • SOURCE CONTROL • DEPLOYMENT • DEVELOPERS VS. DATABASE ADMINISTRATORS
3. INSTALLATION • WEB PLATFORM INSTALLER
4. MODES OR OPERATION • ONLINE DEVELOPMENT • OFFLINE / PROJECT BASED DEVELOPMENT
5. ONLINE DEVELOPMENT • OBJECT BROWSER AND EDITING • VIEW OBJECTS • EDIT OBJECTS • GENERATE SCRIPTS • UPDATE THE DATABASE • DATA TOOLS OPERATIONS WINDOW
6. PROJECT BASED DEVELOPMENT • CREATE NEW PROJECT • IMPORT PROJECT FROM DATABASE
7. PROJECT BASED DEVELOPMENT • WORKING WITH OBJECTS • TABLES • STORED PROCEDURES • ETC…
8. KEY FEATURES • COMPILE TIME ERROR CHECKING • SOURCE CONTROL INTEGRATION • MULTI – TARGETING WITH APPROPRIATE COMPILATIONS • PRE / POST DEPLOYMENT SCRIPTS • INTELLISENSE • SIMPLIFIED SCRIPTS (COMPARING TO DATA DUDE) • FULL VISUAL STUDIO INTEGRATION • FULL BUILD INTEGRATION • FULL CHANGE SCRIPTING • REFACTORING • SCHEMA COMPARE
9. WALKTHROUGH • EXPORT DATABASE • ALTER DATABASE • GENERATE CHANGE SCRIPT • DEPLOY CHANGES • CREATE STORED PROCEDURE
10. QUESTIONS • SERGEY@BARSKIY.COM • HTTP://DOTNETSPEAK.COM