I use this Stored Procedure to compare Tables: Overview: http://www.sql-server-performance.com/articles/dba/database_comparison_sp_p1 .aspx
SP http://www.benzzon.se/forum/uploads/benzzon/2006-03-27_134824_sp_CompareDB.t xt Its free and it works well... Brook -----Original Message----- From: Sonny Savage [mailto:sonnysav...@gmail.com] Sent: July-14-09 4:34 PM To: cf-talk Subject: Re: Compare Two MySQL Databases? 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:324502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4