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.
-2
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;
More details linkedserver: https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver15
Browser other questions tagged database relationship
You are not signed in. Login or sign up in order to post.
Yes, with
SELECTis possible yes. And if the two banks are on different servers, but communicate with each other, it is also possible.– Douglas Garrido
how I would do this SELECT with an external bank ?
– Gabriel Silva
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
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
@Edvaldolucena no, had never seen LINKED SERVER, I’m already taking a look at the link, thanks for the tip.
– Gabriel Silva