Add Database Reference Dialog Box
Database references in SQL projects enable you to incorporate objects that aren’t included in a
project by linking to another project,
file, or published NuGet package. The database
objects added to a project can be part of the same database, a different database on the same
server, or a different database on a different server. For SQL Server development, database
references can be used to link to another database on the same server for three-part naming,
or to link to a different database on a different server for cross-database queries. For databases
with a large number of objects in distinct groups, database references can be used to break up
a database into smaller, more manageable projects. Smaller project size can help to improve
performance and reduce the time required to build a project during iterative local
development.
7
Note