Joining tables from two different servers

Database

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

6 REPLIES
Enthusiast

Re: Joining tables from two different servers

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

Re: Joining tables from two different servers

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

-Chetan

Enthusiast

Re: Joining tables from two different servers

Supporter

Re: Joining tables from two different servers

what do you want to achive this this join?

Enthusiast

Re: Joining tables from two different servers

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

Re: Joining tables from two different servers

Ok, Thanks.

Hence I assume joining two tables from different server in a single query is not possible.

-Chetan