CODEWITHSUNDEEP
sql-servervisual-studiodatabase-projectgdr
Matt
Matt

Reputation: 26981

Unresolved references in Microsoft Visual Studio SQL Database project

I have a MS DataBase project in Visual Studio.

After doing a Schema Comparison, I am trying to generate a deploy script.

The problem is I get hundreds of Unresolved references errors,such as the following two:

Error   385 TSD03006: View: [auditing].[AuditedEntities] has an unresolved
reference to object [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].

Error   387 TSD03006: View: [auditing].[AuditedEntities] contains an unresolved
reference to an object. Either the object does not exist or the reference is
ambiguous because it could refer to any of the following objects:
[INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[C]::[CONSTRAINT_NAME],
[INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[CONSTRAINT_NAME]
or [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS].[C]::[CONSTRAINT_NAME].

The SPROCS never have issues when they run.

Is there a quick and dirty way to fix this?

Perhaps even by turning off referential integrity checks perhaps?

Upvotes: 19

Views: 28090

Answers (2)

stakx - no longer contributing
stakx - no longer contributing

Reputation: 84775

Your database project is missing a reference to the master database.

Assuming that you are talking about a SQL Server Data Tools (SSDT) database project, you can add the missing reference as follows:

  1. In Solution Explorer, open the context menu on the References node and select Add Database Reference… from it:

    Add database reference via Solution Explorer

  2. In the upper portion of the opening dialog window, select the System database option and choose master from the dropdown list.

    Select the System database <code>master</code>

  3. Finally, press the OK button. The database reference should now be added to your project.

Upvotes: 30

Muhammad Omar ElShourbagy
Muhammad Omar ElShourbagy

Reputation: 7068

I added a reference to the master database to resolve this error, which can be achieved through the following steps.

  1. Right click References under your database project
  2. Click Add Database Reference...
  3. Click the `Database project schema (.dbschema) radio button

  4. Browse to the

    C:\Program Files\Microsoft Visual Studio 9.0\VSTSDB\Extensions\SqlServer\2008\DBSchemas\master.dbschema

  5. Click OK

The following question is related. ASP.NET Schema Tables Causing Issues in VSTS

Upvotes: 15

Related Questions