By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,694 Members | 1,294 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,694 IT Pros & Developers. It's quick & easy.

dbdiff utility

P: n/a
Does anyone have or know of a utility that will generate SQL to upgrade one
MySQL database to look like another?
For example 'dbdiff db1 db2' generates the SQL statements that can be
applied to db1 to look just like db2.
Any suggestions short of comparing the database schemas line by line?

Thanks.
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

Hi, Rajesh:

Have you tried extracting the metadata, and then using a simple "diff"
utility such as that which exists on Linux?

John
Rajesh Kapur wrote:
Does anyone have or know of a utility that will generate SQL to upgrade one
MySQL database to look like another?
For example 'dbdiff db1 db2' generates the SQL statements that can be
applied to db1 to look just like db2.
Any suggestions short of comparing the database schemas line by line?

Thanks.

Jul 19 '05 #2

P: n/a

Hi, Rajesh:

Have you tried extracting the metadata, and then using a simple "diff"
utility such as that which exists on Linux?

John
Rajesh Kapur wrote:
Does anyone have or know of a utility that will generate SQL to upgrade one
MySQL database to look like another?
For example 'dbdiff db1 db2' generates the SQL statements that can be
applied to db1 to look just like db2.
Any suggestions short of comparing the database schemas line by line?

Thanks.

Jul 19 '05 #3

P: n/a
Yes John, I have tried doing the diff. However, I still have to write the
alter statement. I was hoping for a tool similar to the dbdiff that Informix
User Group (www.iiug.org) has.... They have a huge arsenal of Informix tools
there.... I wish there were similar tools available for MySQL.

"John" <no****@toplevel.tld> wrote in message
news:wv*****************@newsread2.news.atl.earthl ink.net...

Hi, Rajesh:

Have you tried extracting the metadata, and then using a simple "diff"
utility such as that which exists on Linux?

John
Rajesh Kapur wrote:
Does anyone have or know of a utility that will generate SQL to upgrade one MySQL database to look like another?
For example 'dbdiff db1 db2' generates the SQL statements that can be
applied to db1 to look just like db2.
Any suggestions short of comparing the database schemas line by line?

Thanks.

Jul 19 '05 #4

P: n/a
Yes John, I have tried doing the diff. However, I still have to write the
alter statement. I was hoping for a tool similar to the dbdiff that Informix
User Group (www.iiug.org) has.... They have a huge arsenal of Informix tools
there.... I wish there were similar tools available for MySQL.

"John" <no****@toplevel.tld> wrote in message
news:wv*****************@newsread2.news.atl.earthl ink.net...

Hi, Rajesh:

Have you tried extracting the metadata, and then using a simple "diff"
utility such as that which exists on Linux?

John
Rajesh Kapur wrote:
Does anyone have or know of a utility that will generate SQL to upgrade one MySQL database to look like another?
For example 'dbdiff db1 db2' generates the SQL statements that can be
applied to db1 to look just like db2.
Any suggestions short of comparing the database schemas line by line?

Thanks.

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.