I want to thank all of you that responded to my question. I
have not tried all of the programs yet, but I think I will when I get
time. I have tried DBTools Manager Enterprise Edition and it does
what I was looking for and more. I might even purchase it after I
test it some more and
Some freebies:
PHP: http://sourceforge.net/projects/phpmycomparer
Perl: http://freshmeat.net/projects/mysqldiff/
Cheers,
Andrew
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]
Sent: Thu, 28 Sep 2006 21:06
To: mysql
Subject: comparing two databases
Is there a program
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 statement
> Is there a program out there that I can use to compare two
> databases? Just the structure, not the content.
You might want to look into our development tool "Database Workbench",
it has a database compare tool as well: www.upscene.com
Here's a screenshot/help:
http://www.upscene.com/documen
t: Re: comparing two databases
Steve
>Is there a program out there that I can use to compare two
>databases? Just the structure, not the content.
Here is a query that you might be able to twist into giving you what you
want. Given two dbs @db1 & @db2, it lists structure diffs between them:
Steve
>Is there a program out there that I can use to compare two
>databases? Just the structure, not the content.
Here is a query that you might be able to twist into giving you what you
want. Given two dbs @db1 & @db2, it lists structure diffs between them:
SELECT
MIN(table_name) as Tabl
I use SQLBalance for MySQL.
It's got a couple of minor bugs, but it's been great for us.
http://www.dswsoft.com/sqlbalance.php
Steve Buehler <[EMAIL PROTECTED]> wrote: Is there a program out there that I
can use to compare two
databases? Just the structure, not the content.
Thanks
Stev
When I need to do so, I use mysqldump -d to dump the schemas to files, then use
"diff" on the files. It's pretty good at highlighting the differences.
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 3:06 PM
To: mysql
Subject: comparin
In the last episode (Sep 28), Steve Buehler said:
> Is there a program out there that I can use to compare two
> databases? Just the structure, not the content.
How about something simple like:
mysqldump -d db1 > db1.txt
mysqldump -d db2 > db2.txt
diff -u db1.txt db2.txt
--
Dan Nel
Andrew,
could Jon Frisby's datadiff
http://freshmeat.net/projects/datadiff/?topic_id=66%2C822%2C836%2C861
help here?
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on In
10 matches
Mail list logo
