Re: MySQL Comparison Tool

2008-02-02 Thread Jeff Price
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.

Re: MySQL Comparison Tool

2008-02-01 Thread Ben Nadel
Thanks Randy. I will look into that one. On 2/1/08, Adkins, Randy [EMAIL PROTECTED] wrote: 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

RE: MySQL Comparison Tool

2008-02-01 Thread Adkins, Randy
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

Re: MySQL Comparison Tool

2008-02-01 Thread Josh Nathanson
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

Re: MySQL Comparison Tool

2008-02-01 Thread Ben Nadel
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

Re: MySQL Comparison Tool

2008-02-01 Thread Gerald Guido
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

Re: MySQL Comparison Tool

2008-02-01 Thread Chris Montgomery
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

Re: MySQL Comparison Tool

2008-02-01 Thread Mary Jo Sminkey
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

Re: MySQL Comparison Tool

2008-02-01 Thread Will Tomlinson
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