SSDT Database projects for linked server

[achtro]

Hi all,

I have a situation where i need to access a table from other server(00x) from my database project solution .Things i did to access the table from otherserver

• Created a dacpac for the database that i need to access from otherserver .
• Added reference in my current solution for the dacpac from otherserver with below option.
• when i am trying to reference this table1 from otherserver i need to use $(otherServer) variable in my sps/functions/views, example select * from [$(otherServer)].[db1].[dbo.].[table1]. The server variable value is a required field while adding the dacpac solution but the database variable is not a required field i can just cleanup the values from database variable value as above, is there any word aroudn solution that i can ignore the $ sign in the server variable section and just refer my table as below?

select * from [otherServer].[db1].[dbo.].[table1].


Any help is much apprciated

Continue reading...