Thanks, but I decided to grunt through it using PHPMyAdmin. This doesn't happen very often, so I can't see investing in a tool at this point.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com >-----Original Message----- >From: Markus Grossrieder [mailto:[EMAIL PROTECTED] >Sent: Sunday, August 10, 2008 8:46 AM >To: Jerry Schwartz; mysql@lists.mysql.com >Subject: Re: Transplanting table structure changes > >Hi Jerry, > >there's a (commercial) product called SQLyog, with an excellent schema >synchronization tool (at least in the enterprise version) which procudes >ready-made "alter table" scripts. > >Probably other db tools have this functionality too ... > >HTH, regards, >Markus > >----- Original Message ----- >From: "Jerry Schwartz" <[EMAIL PROTECTED]> >To: "'Martijn Tonies'" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> >Sent: Friday, August 08, 2008 8:44 PM >Subject: RE: Transplanting table structure changes > > >> >You might want to try our Schema Compare tool inside Database >Workbench. >>>This tool also has a "script recorder" that can record any changes you >>>make >>>to (meta)data in order to help you keep your change scripts. >>> >> [JS] Ah! I just discovered that if I hit what looks like the "record" >> button, I get a script that is just the ALTER TABLE DDL that I need. I >> thought I was going to have to record my own. >>> >>>Martijn Tonies >>>Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, >>>Oracle & >>>MS SQL Server >>>Upscene Productions >>>http://www.upscene.com >>>My thoughts: >>>http://blog.upscene.com/martijn/ >>>Database development questions? Check the forum! >>>http://www.databasedevelopmentforum.com >>> >>> >>>-- >>>MySQL General Mailing List >>>For list archives: http://lists.mysql.com/mysql >>>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >>>infoshop.com >> >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> No virus found in this incoming message. >> Checked by AVG - http://www.avg.com >> Version: 8.0.138 / Virus Database: 270.6.0/1601 - Release Date: >8/8/2008 >> 9:02 AM >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
