Re: [PHP] Script to Compare Database Structures

2009-08-05 Thread Matt Neimeyer
I finally got a chance to play with this and it looks like it is exactly what I need. Thanks! On Fri, Jul 31, 2009 at 11:50 PM, German Geek wrote: > have you tried mysqldiff? >> I want to be able to compare the structure of two different clients >> databases that might be on different servers tha

Re: [PHP] Script to Compare Database Structures

2009-08-02 Thread Mattias Thorslund
Look into the Reverse module of PEAR MDB2. http://pear.php.net/manual/en/package.database.mdb2.intro-reverse-module.php Cheers, Mattias Matt Neimeyer wrote: I know I CAN hack something together but I hate to reinvent the wheel. I want to be able to compare the structure of two different clien

Re: [PHP] Script to Compare Database Structures

2009-07-31 Thread Paul M Foster
On Fri, Jul 31, 2009 at 05:38:44PM -0400, Matt Neimeyer wrote: > I know I CAN hack something together but I hate to reinvent the wheel. > > I want to be able to compare the structure of two different clients > databases that might be on different servers that are firewalled away > from each other

Re: [PHP] Script to Compare Database Structures

2009-07-31 Thread German Geek
have you tried mysqldiff? ++Tim Hinnerk Heuer++ http://www.ihostnz.com (should be .org) Sponsors welcome to put ads under a linked to page. This is not automated just yet. Only image, swf or preferably text or short html ads, no animations please. Price negotiable. 2009/8/1 Matt Neimeyer > I

[PHP] Script to Compare Database Structures

2009-07-31 Thread Matt Neimeyer
I know I CAN hack something together but I hate to reinvent the wheel. I want to be able to compare the structure of two different clients databases that might be on different servers that are firewalled away from each other. Given the two structures it will list all the SQL commands needed to mak