MSDN Archive Home
Help and FAQs
Visual Studio Team System - Database Edition msdb Sample Database Projects
All Resource Updates
Change History (all pages)
Resource Page Description
msdb 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.
You will need to have Visual Studio Team System for Database Professionals 2005 SR1 or Visual Studio Team System 2008 - Database Edition installed.
Download the .zip files from the 'Releases' tab and follow the instructions.
Additional information on Cross-Database References:
Overview of Cross-Database References
Apr 29 2008 at 8:52 PM
, version 10
Sign in to add a comment
Visual Studio Team Sys...
Tue Apr 29 2008 at 7:00 AM
More Tags ...
Visual Studio 2005
Visual Studio 2008
Visual Studio 2010
Manage Your Profile
MSDN Flash Newsletter
© 2008 Microsoft Corporation. All rights reserved.