+1 for SQLyog. SQLyog's schema and data sync tools are great IMHO.
G! On Tue, Jul 14, 2009 at 7:33 PM, Sonny Savage <[email protected]> wrote: > > 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:324501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
