Continuing with the VSTS: DB Best Practices post series, let’s take a look at managing data motion in your deployments. This will be Part 1 of a 2 part post. In the first post we will take a look at managing data motion necessary to make table schema...

In the March edition of MSDN we provided an overview of Server Projects and how to reference the master.dbschema file to resolve references to system objects. If you have a project that references the master.dbschema file, you may have noticed it takes...

Up to the release of Visual Studio Team System 2008 Database Edition GDR a design database was used to store and validate the database project's schema model. The design database was dynamically created when you opened a database project (.dbroj). The...

We are receiving reports from customers that they are encountering a deployment failure of their database projects using the GDR release. This issue typically occurs when the project is copied to a new location on disk or when the solution configuration...

Jamie Laflen and I wrote an article for this month's issue of MSDN magazine . The article briefly introduces most of the new features of the VSTSDB GDR release. The article covers the following features: Offline Schema Development Product Architectural...

Continuing with the Best Practices post series, let's take a look at Offline Schema Development to set the stage for future topics. This posting is for DBAs and Database Application Developers that are not using the VSTSDB or have just started using VSTSDB...