Creating a data project with SQL Project


show more Creating a data project with SQL Project provides you with in-depth training on Developer. Taught by Walt Ritscher as part of the Visual Studio 2010 Essential Training show less
please wait ...

Creating a data project with SQL Project

Here is a problem that torments developer teams everywhere. If you've ever worked with database changes and multiple developers, you know that keeping your database schema in sync is a never-ending task. If someone makes a change to the database schema, you must ensure that that change propagates to each developer's computer, makes it to the test team, and gets updated on all your production servers. The trouble is compounded when debugging previous versions of your product. Now you have to ensure that the database matches the code that is stored in the source control.

Some teams attempt to solve this problem by having a folder full of SQL scripts that contain the information to update the schema. These scripts can quickly get out of sync with the real database schema, however. Believe me, I know this from first-hand experience. To solve these problems, Microsoft created a special database project known as SQL project. Before I continue, I should add that these features are only...

Creating a data project with SQL Project
Video duration: 6m 24s 8h 9m Intermediate

Viewers:

Creating a data project with SQL Project provides you with in-depth training on Developer. Taught by Walt Ritscher as part of the Visual Studio 2010 Essential Training

please wait ...