0
Is there any way beyond Linked to connect two DBMS ?
Problem:
I need to use the tables of another bank that is on another server with the SQL SERVER installed.
My current server is also SQL Server;
1 answer
2
You have to create a linkedServer between servers. Through Linked Server you create a communication link between one server and another so you can have free access to the data stored on the other server, but the important thing is that the user who will be used to create Linked has access permission to work with this data
Example Server1, instâcia "192.168.0.10" and the Server2, instance "192.168.0.11", and you will have to access the table "Client" of the final server 11, then make a Linked Server, can be done by Studio itself, after the query will be made as below:
SELECT * FROM [192.168.0.11].[NOME_BANCO].DBO.Cliente
If in Linked server you created using IP will be done as above, but if done using the instance, exchange the IP by the SQLSERVER instance name.
Browser other questions tagged sql sql-server
You are not signed in. Login or sign up in order to post.