Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Diff between two tables on two separate servers?

Codes here !

Moderators: macek, egami, gesf

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!
Khem1
New php-forum User
New php-forum User
 
Posts: 1
Joined: Thu May 03, 2012 7:27 am

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.
User avatar
freshnet
php-forum Active User
php-forum Active User
 
Posts: 252
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.