Sonny & Gerald, Thanks for the suggestion! I downloaded it and I have a few questions:
Can I have it just *show* me the differences instead of running a Sync? I don't want the *data* copied, I just want to know which field definitions might be different. Would you use database sync or schema sync for something like this? Or is there another compare option? Thanks! MarieT --- On Tue, 7/14/09, Gerald Guido <gerald.gu...@gmail.com> wrote: > From: Gerald Guido <gerald.gu...@gmail.com> > Subject: Re: Compare Two MySQL Databases? > To: "cf-talk" <cf-talk@houseoffusion.com> > Date: Tuesday, July 14, 2009, 4:53 PM > > +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 <sonnysav...@gmail.com> > 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 <mt4yl...@yahoo.com> > 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:324504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4