On May 31 2006, Microsoft announced a new Team Edition specifically targeted at database professionals called Team Edition for Database Professionals. A database professional can be defined as an architect, developer, administrator, or other professional that works within the SQL Server database (for example, a business intelligence specialist). The product is currently targeted at database developers and administrators, but future versions will provide support for architects (data modeling) and more features for IT operations.
This product fills a missing gap in the Team System family. You finally have a nice way to utilize all that Team Foundation Server has to offer, including version control and work item tracking, with your database schema. No more wondering what changes you made between your test database and your production database. No more question of whether you made a copy of that stored procedure before you added the new code. With Team Edition for Database Professionals, these and many other worries are taken care of.
This chapter is all about Team Edition for Database Professionals. We start this chapter with an overview of why this product is important, and how it fits into Team System. Then you delve into the details of how to use the product, including how to create a database project, and how to import and manage your database schema. You look at how to implement unit testing against your database, how to deploy your database changes, and even how to generate test data for the database.
This chapter was written using Community Technology Preview (CTP) 3 of TeamEdition for Database Professionals. Many things may change between a CTP and the final release of the product. As such, some of this information may be inaccurate in relation to the released version.