Sorry, that script was for MSSQL.... -----Original Message----- From: Barney Boisvert [mailto:[email protected]] Sent: July-14-09 4:31 PM To: cf-talk Subject: Re: Compare Two MySQL Databases?
Take a structure-only (no data) mysqldump on both servers, and then use your choice of diff tools (command-line diff, Eclipse, BeyondCompare, etc.) to compare them. Certainly not a particularly elegant solution, but it's served me well in the past. cheers, barneyb On Tue, Jul 14, 2009 at 4: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:324503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
