SQLTeam.com | Weblogs | Forums

Omitting SSDT DB Projects Linked Server References


#1

DB with artefact's that reference a Linked Server to external source (ODBC). SSDT/DB Projects References is unable to validate this external source and therefore fails the build (and therefore unable to create DACPAC)

Since the artefact's need to reference the Linked Server, is there a method to tell SSDT/DB Projects to ignore the references and proceed with a build.

Thanks


#2

Add the objects referencing the linked server to a post build script.
I know, it sucks, but there is no other way AFAIK.


#3

Thanks for the confirmation.

Also came across an article showing another possible method creating a dummy table-valued function (TVF). Please see below link