Toad World® Forums

Merging Data from tables in different servers

I am new to TOAD and not a expert on database. I am involve in analytic and reporting in my company. I have been using TOAD to pull data from different SQL servers and loved the query builder, but I need to merge data from tables in different servers and I do not know how to do that using TOAD. Can anyone help please. I have read access on the servers.


Toad Data Point Pro Edition is the only Toad product that allows you to execute queries across different servers (They do not all have to be SQL Server either).

I guess I am out of luck on that. I use the Xpert Edition. Thanks for your response.