For those not fortunate enough to use MySQL, RedGate's SQL Compare and SQL Data
Compare absolutely rock!
I didn't know the same type of tools existed for mySQL, I'll have to check out
everything that folks have recommended.
:[EMAIL PROTECTED]
Sent: Friday, February 01, 2008 12:07 PM
To: CF-Talk
Subject: MySQL Comparison Tool
Hello, I from Google that there are many tools out there for MySQL
comparison tools, but I was wondering if anyone had any suggestions.
Basically, all I need it to do is:
* Point to two
Navicat has the ability to compare database structures and show the
differences as well as the SQL to sync the structures.
Same for data sync.
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Friday, February 01, 2008 12:07 PM
To: CF-Talk
Subject: MySQL Comparison Tool
Hello, I from Google that there are many tools out there for MySQL
comparison tools, but I was wondering if anyone had any suggestions.
Basically, all I need it to do is:
* Point to two different database
* List out different tables
* List out differences in columns (including data type,
Navicat has the ability to compare database structures and show the
differences as well as the SQL to sync the structures.
Same for data sync.
Anytime I see Navicat mentioned I have to give it a +1. Really a great
piece of software, and well worth the relatively small investment.
-- Josh
It's especially good that we are already using Navicat for regular DB admin.
I just wasn't aware that it could do Diff comparison. Badass.
--
Ben Nadel
Adobe Community Expert
Adobe Certified Advanced ColdFusion Developer
Manager New York ColdFusion User Group
http://www.bennadel.com
Need
MysqlYog Enterprise has some pretty amazing DB sync utilities. It ever
writes the SQL to sync up the table structure.
http://webyog.com/en/
Toad for Mysql is my tool of choice these days. No structure sync though.
On Feb 1, 2008 10:06 AM, Ben Nadel [EMAIL PROTECTED] wrote:
Hello, I from
Gerald Guido said the following on 2/1/2008 12:38 PM:
MysqlYog Enterprise has some pretty amazing DB sync utilities. It ever
writes the SQL to sync up the table structure.
http://webyog.com/en/
This is what I use and I've been very happy with it so far.
--
Best regards,
Chris Montgomery
It's especially good that we are already using Navicat for regular DB admin.
I just wasn't aware that it could do Diff comparison. Badass.
I'm a big fan of Navicat as well and use it regularly. For a free alternative
though, Toad for MySQL is pretty decent and includes both schema and data
It's especially good that we are already using Navicat for regular DB admin.
I just wasn't aware that it could do Diff comparison. Badass.
It's funny you brought this up. I had a few mysql db's I needed to match up.
I've looked at navicat's data sync tool before but was afraid I'd do something
10 matches
Mail list logo