Re: MySQL Comparison Tool
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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Comparison Tool
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 [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, properties) Thanks, -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL Comparison Tool
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, properties) Thanks, -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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, properties) Thanks, -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Comparison Tool
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 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Comparison Tool
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 ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Comparison Tool
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 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, properties) Thanks, -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Comparison Tool
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 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Comparison Tool
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 comparison tools: http://www.quest.com/toad-for-mysql/ --- Mary Jo Sminkey Author of CFWebstore, ColdFusion Ecommerce http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Comparison Tool
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 really bad. :) So I looked into it again after readin this thread and was able to match up what I needed and get my *hit straight! Thanks dude, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4