All Forums Database
chodankarcc 3 posts Joined 10/13
08 Nov 2013
Joining tables from two different servers

Hi There,
We are using TD14. We have one requirement where we want to join two tables from two different servers.
Is this possible to join such tables in single query?
If No, then please let me know alternatives.
Thank you!
-Chetan

M.Saeed Khurram 544 posts Joined 09/12
08 Nov 2013

Hi,
I think it would not be possible for a query to get data from two different servers. One alternative is to copy the smaller table on the other server and then run your query.
 

Khurram

chodankarcc 3 posts Joined 10/13
08 Nov 2013

I see.. In my case both tables are having more than 30 millions records. So i need to check on better option.
-Chetan

M.Saeed Khurram 544 posts Joined 09/12
ulrich 816 posts Joined 09/09
08 Nov 2013

what do you want to achive this this join?

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Raja_KT 1246 posts Joined 07/09
08 Nov 2013

Hi,
You  can fastexport the data from source and then fload into your target. Also you can ask your DBA to do this task. There are other ways to do but these are common and simple ones for one-off job.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

chodankarcc 3 posts Joined 10/13
10 Nov 2013

Ok, Thanks.
Hence I assume joining two tables from different server in a single query is not possible.
-Chetan

You must sign in to leave a comment.