0
Hello.
We had an SQL Server with three banks, one of the application I develop, another two of two different systems, the Company’s ERP system and the Online Ordering system.
This system of Online Orders runs 24hs, so it is always updating the bank, inserting new items, comparing descriptions and consulting the stock balance of the products in the ERP System. This has weighed a lot on the performance where another system runs to download the information from one to the other.
In my system, I need to cross-check the information from the two banks with mine, for example, to find out if a customer is registered, who the seller is, or if an order has already been imported. There are quiet days but others give timeout error in a consultation or other.
We decided to put the Online System database on another server and solved the performance problem. But we created another one. How to make a query by crossing databases and tables of two servers?
I’m researching, but I haven’t reached a conclusion yet. I want to create views of the tables I need on my server with the tables of the Online database, I don’t know if it is possible to do this. Has anyone ever had this problem of cross-referencing information on two servers?
The system I’m developing is in VB.Net.
I had a similar problem, but it was not a performance problem. We had 4 bases, one location and 3 in remote locations. We created a snapshot replication of remote banks. So periodically the local server "received" the snapshot of the remote banks. Snapshots were for query only and the location was normally used.
– Robss70
Have you considered using Linked Server?
– cantoni
@Yes, I was researching how to do this Linked Server. This is still news to me, but it seems to be a good alternative.
– Lindomar Lemos
@Lindomarlemos, this is a good option if the servers are within the same network.
– cantoni
I think you’re looking for something similar to this.
– Daniel Junior
Yes. I saw the syntax: {LINKED_SERVER. }DATABASE.SCHEMA.OBJECT. Where is LINKED_SERVER should I put the server IP? Then: BD2.dbo.Clients. Complete would be: {192.168.1.1 affiliate}. DB2.dbo.Customers. Would it be something like this?
– Lindomar Lemos