SSDT with Remote Linked Server Connections
hi,
one of big issues when using openquery in view or sproc linked server - solution gives unresolved references error cannot suppress. of these databases not sql server i.e. oracle/informix/progress/odbc , cannot imported or referenced via project. makes whole solution painful. i'd love ability ignore validation remote database references. validate main project db , not worry external dependencies may have no control over.
where referencing 3rd party database sql server based , can import database want import objects not whole database. drag , drop exercise each dependant object (painful) project tries validate whole database , end loads of warnings can't suppressed - suppress sql warnings seems have no effect.
anyone having same issue there work around etc.?
regards
toby
hi,
you can add linked server project (we use so for oracle-db):
click on project --> add --> new item --> linked server
in file add:
execute sp_addlinkedserver linkedservername
go
that's it.
hope helps :-)
SQL Server > SQL Server Data Tools
Comments
Post a Comment