Share via

Visual Studio Database Project: Import linked server

  • Article

Question

Monday, August 4, 2014 2:45 PM

Visual Studio 2012

I created a new database project and imported an existing SQL database.

I am attempting to fix 'unresolved references'. This are largely due to a linked server referenced by my SQL database.

A common solution I have seen is to create a further database project based on my linked server and reference that in my original database project.

These solutions explain importing my linked server, or a DACPAC of it, into its database project.

I can not work out how to import a linked server into a database project, or create a DACPAC of a linked server.

If I attempt to import a database into a database project the only options I get are to import from a connection to a SQL database on a server, not a linked server on a server. 

How do I import a linked server into a database project?

Thanks

All replies (1)

Wednesday, August 6, 2014 9:11 AM âś…Answered

Hi bob132,

Actually you could use the a Database Reference.

Reference:

http://stackoverflow.com/questions/14635244/do-i-need-a-database-reference-for-a-linked-server-in-a-sql-server-database-proj

http://dba.stackexchange.com/questions/56437/using-a-linked-server-with-openquery-in-a-database-project

About how to add references to Database Projects, see:

http://msdn.microsoft.com/en-us/library/dd193259(v=vs.100).aspx

This link is about the VS2010, but I think you could also get it if you right click your database project->Add (I test it in VS2013.).

Best Regards,

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. <br/> Click <a href="http://support.microsoft.com/common/survey.aspx?showpage=1&scid=sw%3Ben%3B3559&theme=tech"> HERE</a> to participate the survey.