Diff between two tables on two separate servers?

Codes here !

Moderators: macek, egami, gesf

Khem1
New php-forum User
New php-forum User
Posts: 1
Joined: Thu May 03, 2012 7:27 am

Diff between two tables on two separate servers?

Postby Khem1 » Mon May 07, 2012 5:26 am

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!

User avatar
freshnet
php-forum Active User
php-forum Active User
Posts: 283
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

Re: Diff between two tables on two separate servers?

Postby freshnet » Mon May 07, 2012 10:44 am

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.


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 1 guest