Is it possible to list 2 tables from 2 different banks?

Question

Asked 5 years, 5 months ago

Viewed 654 times

4

I’m looking to relate 2 different database tables. I’m using SQL Server SSMS 17.9.1.

TBL1 in DB1
TBL2 in DB2

Scenarios:

Would there be a way out of these two scenarios? Initially the two banks will be on the same server, but later the BD 2 can go to another server.

1

Yes, with SELECT is possible yes. And if the two banks are on different servers, but communicate with each other, it is also possible.

– Douglas Garrido

2019/06/13 at 13:43
how I would do this SELECT with an external bank ?

– Gabriel Silva

2019/06/13 at 13:45
As far as I know, although it is possible to access another database via FDW (Foreign Data Wrapper) in the SQL/MED standard, it is not possible to define a Constraint between different databases.

– anonimo

2019/06/13 at 13:49
2

Have you researched LINKED SERVER ? https://docs.microsoft.com/pt-br/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-2017

– Edvaldo Lucena

2019/06/13 at 14:17
@Edvaldolucena no, had never seen LINKED SERVER, I’m already taking a look at the link, thanks for the tip.

– Gabriel Silva

2019/06/13 at 14:57

1 answer

Browser other questions tagged database relationship

You are not signed in. Login or sign up in order to post.

by Igor Resende • 5 points · Answer 1 · 2021-04-12T18:50:36+00:00

Yes, it is possible through linkedserver. Where you take Banco A and Banco B (ipdobanco/Bank name in linkedserver) and assemble your query

select * from Bancoa.dbo.tableA;

Select * from Bancob.dbo.tableA;