/database_compare.png
Best Regards,
COS
- Original Message -
From: "Steve Buehler" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Thursday, September 28, 2006 5:06 PM
Subject: comparing two databases
> Is there a program out there that I can use to compare two
> dat
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
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
: mysql
Subject: comparing two databases
Is there a program out there that I can use to compare two databases? Just the
structure, not the content.
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
Is there a program out there that I can use to compare two
databases? Just the structure, not the content.
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ws on InnoDB
sql query
- Original Message -
From: "Andrew Braithwaite" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, November 28, 2002 4:41 AM
Subject: comparing two databases in readiness for implementing replication
> Hello all, I w
Hello all, I wonder if you can help me?
Background:
I have two databases (on different machines).
I have a requirement to move to having multiple slaves to do the queries
involved, at the moment we have data on both machines and our apps choose
the machine that has the necessary data to satisfy th
12 matches
Mail list logo