Create view by accessing tables from other server

Question

Create view by accessing tables from other server

adisql

SSCrazy

Points: 2893
More actions
June 18, 2020 at 2:51 am

#3764071

Hi,
Need to create a view in a database in server A by using the tables from other database in server B.
Is it possible ?
Any suggestions please.

Thank you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27055 More actions · Answer 1

A linked server perhaps?

https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver15

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 2

I would also recommend using synonyms - and possibly a separate schema for the synonyms. This would allow you to change the linked server and update just the synonyms without having to change any views or code.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 3

How often will this view be queried? Having queries frequently go across a linked server is a notorious way to kill performance. Does the consumer of this query need real time data or can it be updated periodically on Server A from Server B?