I've used SQLyog and found it to be pretty impressive. It's around $100, but there's a 30-day trial that might get you through this issue: http://www.webyog.com/en/downloads.php#sqlyog
Edward "Sonny" Savage On Tue, Jul 14, 2009 at 7:24 PM, Marie Taylore <[email protected]> wrote: > > What's the easiest & quickest way to compare two MySQL Schemas (databases)? > > I don't need to compare the *data*... just the tables and their field > definitions. > > My production instance is getting an error that my test instance is not. > The code is identical, so I figure I must have left something out of the > database updates, but going through all those tables and fields by hand will > take forever. > > Just thought I'd see if anyone here has any tips. > > Thanks! > > MarieT > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
