Visual Studio Database Project Build Error

Question

Visual Studio 2013 - Attempting to build a Database Project.

Build Error with a SQL view due to it not recognising a Synonym.

When I right click the database project and build my Database I get the following error:

D:\Users\Dave\Documents\Visual Studio 2013\Projects\DataSync\UAT_DB1\UAT_DB1\dbo\Views\uvw_FirstFix.sql(12,7): Error: SQL71501: View: [dbo].[uvw_FirstFix] has an unresolved reference to object [dbo].[Synonym_X].

Now the view [dbo].[uvw_FirstFix] has a reference to the Synonym, [Synonym_X] which references a table in a different database. I have added it the second database into the Visual Studio project and added a database reference to it.

The problem seems to be Visual Studio not being able to recognise the synonym as a synonym.

Has anyone come across this problem and how to resolve it please ?

Do you already see this? stackoverflow.com/questions/18096029/… — dwir182
– dwir182, Commented Oct 11, 2018 at 6:12
Is the synonym defined in the database project? Besides, why Visual Studio 2013? SSDT is a separate download now which can be installed separately. A lot of bugs have been fixed since 2013 — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Oct 12, 2018 at 10:06

Peter · Accepted Answer · 2018-10-12 06:57:27Z

1

Please review and correct your VIEW in Database View: [dbo].[uvw_FirstFix].

There's a reference to it and compiler is unable to find it.

answered Oct 12, 2018 at 6:57

Peter

7431 gold badge7 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Visual Studio Database Project Build Error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related