Re: Script to Compare Database Structures
| From: | German Geek | Date: | Sat, 01 Aug 2009 03:50:45 +0000 |
| Subject: | Re: Script to Compare Database Structures | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296153@lists.php.net to get a copy of this message | ||
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 <matt@neimeyer.org>
> 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 make the database structure the same.
>
> In a perfect world on one side you would pull up a PHP page that does
> a "generate structure" which would create a downloadable file which
> you could then upload to the other system which would then give a
> listing of the SQL commands needed to make the local structure match
> the uploaded structure.
>
> Thanks in advance...
>
> Matt
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>