Visual Studio 2010 Database Projects
Pluralsight
Course Summary
Learn how to use Visual Studio Database Projects to manage your database code, reverse engineer an existing database, create realistic test data, even unit test your T-SQL
-
+
Course Description
In many organizations, the .Net developer is also tasked with the coding and creation of the database to hold their application data. Often they need to take over projects for which no database code can be found. Then once they've created code, they have to track changes manually in order to provide the DBA with change scripts. All the while thinking, "there's got to be a better way!" Fear not .Net Developer, it's Data Dude to the rescue! Originally code named "Data Dude", Visual Studio Database Projects havef gone through several name changes since it's inception with VS 2005. In Visual Studio 2010 it became another project type, a Database Project. In this series you will learn how to harness the power of the Database Project to create a new database, or reverse engineer the code for an existing database. You will learn how to refactor, and let Visual Studio keep track of the changes, to let it automatically generate change and deployment scripts. Finally, you'll learn how to take advantage of Visual Studio's powerful data generation capabilities to create realistic test data.
-
+
Course Syllabus
Creating and Refactoring- 24m 56s
—Introduction 3m 12s
—Creating a database project 13m 19s
—Introduction to Adding New Objects 0m 17s
—Adding New Objects 3m 19s
—Introduction to Database Refactoring 0m 28s
—Database Refactoring 4m 1s
—Summary 0m 20sDeployment Options- 20m 1s
—Introduction 1m 58s
—Database Deployment 17m 22s
—Summary 0m 41sData and Schema Comparisons, Pre and Post Deployment Scripts- 22m 58sData Generation- 18m 21sUnit Testing- 23m 24s