Re: comparing two databases

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

Re: comparing two databases

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:

Re: comparing two databases

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

RE: comparing two databases

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

Re: comparing two databases

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 Nelson

RE: comparing two databases

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: comparing

Re: comparing two databases

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 Steve

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: SELECT MIN(table_name) as

RE: comparing two databases

: 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: SELECT MIN

Re: comparing two databases in readiness for implementing replication

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