wsantos Posted August 20, 2007 Share Posted August 20, 2007 Precondition: Two databases on separate servers There is no way that this two databases be merged nor put on the same box ever. Question: I am to make a query that requires few data from one db and a few from the other one. How do I tackle this. Approach 1: I tried a query from one server and use the uniqueid as a parameter for a loop query on the other. Result: Performance Hit Web Browser Timeout Approach 2: I tried a Left outer join across server. Result: Cross server join is not impossible...as I was told Quote Link to comment Share on other sites More sharing options...
fenway Posted August 21, 2007 Share Posted August 21, 2007 If you make the login credentials the same, you might be able to connect to both; oh, but they're on separate servers... you can try FEDERATED tables. Quote Link to comment Share on other sites More sharing options...
wsantos Posted August 23, 2007 Author Share Posted August 23, 2007 Sorry got tied up...I tried the federated table it worked when I need to get data from one server. But the problem came when I tried it with two separate server aside from my local machine. Thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted August 27, 2007 Share Posted August 27, 2007 Sorry got tied up...I tried the federated table it worked when I need to get data from one server. But the problem came when I tried it with two separate server aside from my local machine. Thanks Not sure what you mean, can't you just use two separate federated tables? Quote Link to comment Share on other sites More sharing options...
wsantos Posted August 27, 2007 Author Share Posted August 27, 2007 That was what I did that did not work. I had a few typo errors that's why it didn't work. It's working now.Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.