Diff between two tables on two separate servers?

[Khem1]

Hello,

I have a page that displays a list of phone numbers in use on a table/database/server that I have readonly access to. I want to make a list of our entire phone number range, and diff this with the numbers in use table and output all open numbers. I feel like this would be pretty straight forward to do if I could add the table on the readonly database and insert the entire phone number range, unfortunately I cannot.

Is there a fairly simple way to do this? I have a mysql server running on another server that I have full access to as well.

NOTE: The readonly database is not MySql, I'm using ODBC to connect. The full access database is MySql

Thanks!

[freshnet]

When you say 'diff' are you referring to the third-party tool? If so, they should have documentation on whether you can use connection strings that specify a server name. I don't see why that shouldn't work, but personally I've never used it before.