Resource Page Descriptionmsdb database project samples for Visual Studio Team System - Database Edition
You can create or import database objects that refer to objects in other databases(or with MSDB database projects). These cross-database references require that you define a corresponding reference in the properties of your database project. If you refer to objects in other databases but you do not define the corresponding references in your project, warnings will appear. For each database that you reference, you can define SETVAR variables that correspond to the server and database that you want to reference. When you modify an object definition to include the reference, you can define it by using these variables instead of the explicit names of the server and the database. When you build the database project, the variables are replaced by the values that you specified.
To make cross-database references specific to a particular build configuration, you must define the SETVAR variables for those references in terms of MSBuild variables. For example, you can use one set of MSBuild variables when you build and deploy a database project to a staging server and another set when you build and deploy the same project to a production server. If you define the SETVAR variables for a cross-database reference in terms of server and database names, the reference will function the same way, regardless of which build configuration you specify.
Requirements
You will need to have Visual Studio Team System for Database Professionals 2005 SR1 or Visual Studio Team System 2008 - Database Edition installed.
Installation
Download the .zip files from the 'Releases' tab and follow the instructions.
Additional information on Cross-Database References:
Overview of Cross-Database References .