12 messages in com.mysql.lists.mysqlRe: comparing two databases| From | Sent On | Attachments |
|---|---|---|
| Steve Buehler | 28 Sep 2006 13:06 | |
| Dan Nelson | 28 Sep 2006 13:10 | |
| John Trammell | 28 Sep 2006 13:11 | |
| Cory Robin | 28 Sep 2006 13:18 | |
| Peter Brawley | 28 Sep 2006 13:26 | |
| Dye, Aleksander | 28 Sep 2006 22:32 | |
| Martijn Tonies | 28 Sep 2006 23:35 | |
| mark addison | 29 Sep 2006 03:52 | |
| Andrew Braithwaite | 29 Sep 2006 09:34 | |
| Renito 73 | 29 Sep 2006 19:19 | |
| André Hänsel | 29 Sep 2006 19:33 | |
| Steve Buehler | 01 Oct 2006 07:15 |
| Subject: | Re: comparing two databases |
|---|---|
| From: | mark addison (mark...@itn.co.uk) |
| Date: | 09/29/2006 03:52:29 AM |
| List: | com.mysql.lists.mysql |
On Thu, 2006-09-28 at 15:06 -0500, Steve Buehler wrote:
Is there a program out there that I can use to compare two databases? Just the structure, not the content.
SqlFairy (http://sqlfairy.sourceforge.net/) has a sqlt-diff tool that will output the differences as a set of sql alter statements. Easiest way to install on nix box is cpan: $ sudo cpan SQL::Translator).
mark
--
MARK ADDISON WEB DEVELOPER
200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E MARK...@ITN.CO.UK WWW.ITN.CO.UK Please Note:
Any views or opinions are solely those of the author and do not necessarily
represent
those of Independent Television News Limited unless specifically stated.
This email and any files attached are confidential and intended solely for the
use of the individual
or entity to which they are addressed.
If you have received this email in error, please notify post...@itn.co.uk
Please note that to ensure regulatory compliance and for the protection of our
clients and business,
we may monitor and read messages sent to and from our systems.
Thank You.