Another in the series of recordings that I have done for INETA live.
Part 1
Abstract:Most developers face the tasks of managing and updating database schemas as part of their daily jobs. Even in organizations with a dedicated team of DBAs, the developers have to manage changes to table structures, views, and stored procedures to match the logic of their systems under development. While the Microsoft Visual Studio Team Edition for Database Professionals (aka DBPro) was originally built for DBAs to use to manage sophisticated database schemas, Microsoft has made it easy for developers to embrace the DBPro tools as an extension to the core Developer Edition tools. And with Visual Studio 2010 you don’t even have to install DBPro separately. In this talk, which is applicable to developers and DBAs alike, learn how to use the power Visual Studio database projects to get your schema definitions in source control, manage changes to databases across multiple environments, generate test data, write executable database test cases, and more. No matter which version of Visual Studio you use, you’ll find tools that will make your life with data much easier to manage.