You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/ssdt/add-database-reference-dialog-box.md
+13-9Lines changed: 13 additions & 9 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,16 +1,17 @@
1
1
---
2
-
title: "Add Database Reference Dialog Box | Microsoft Docs"
2
+
title: Add Database Reference Dialog Box
3
3
ms.prod: "sql"
4
4
ms.technology: ssdt
5
5
ms.topic: conceptual
6
6
author: "markingmyname"
7
7
ms.author: "maghan"
8
8
ms.reviewer: ""
9
-
ms.custom: "SSDT"
10
-
ms.date: "02/09/2017"
9
+
ms.custom: seo-lt-2019
10
+
ms.date: 02/09/2017
11
11
---
12
12
13
13
# Add Database Reference Dialog Box
14
+
14
15
This topic describes the procedures you can perform in the **Add Database Reference** dialog box.
15
16
16
17
Database references let you:
@@ -23,7 +24,8 @@ In a composite project, database references partition a large database into seve
23
24
24
25
Database references can be made to a database project in the current solution or to a DACPAC. Adding a database reference to a project changes project dependencies and build order.
25
26
26
-
## Selecting the Database to Reference
27
+
## Selecting the Database to Reference
28
+
27
29
You can reference another database project in the same solution, a system database, or a DACPAC.
28
30
29
31
If there is more than one database project in your solution, **Database projects in the current solution** is enabled. You can reference another database in the solution.
@@ -32,7 +34,8 @@ Select **System database** if you intend to select one of the system databases a
32
34
33
35
Select **Data-tier Application (.dacpac)** to reference a database in a DACPAC, and browse to the directory with the DACPAC file.
34
36
35
-
## Selecting the Database's Relative Location
37
+
## Selecting the Database's Relative Location
38
+
36
39
After you select the database you want to reference, you can specify the expected location of a database object, relative to the referencing project.
37
40
38
41
References can be resolved for objects in one of the following locations:
@@ -54,7 +57,8 @@ If you selected **Different database, different server**, a (SQLCMD) server vari
54
57
> [!IMPORTANT]
55
58
> In some situations, you can create a database reference that has the same name as an existing database reference. Two database references with the same name can result in unexpected behavior. In this situation, delete both database references.
56
59
57
-
## Common Procedures
60
+
## Common Procedures
61
+
58
62
The following are common procedures:
59
63
60
64
### To create a reference to a database on the same server
@@ -107,6 +111,6 @@ When you publish this project, you can deploy composite projects in the same sol
107
111
108
112
3. In the **Advanced Publish Settings** dialog box, make sure that **Include composite objects** is checked in the **Advanced Deployment Options** list.
0 commit comments