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 ...
----- Original Message -----
From: "Jerry Schwartz" <jschwartz@stripped>
To: "'Martijn Tonies'" <m.tonies@stripped>; <mysql@stripped>
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
>>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.
>>Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
>>MS SQL Server
>>Database development questions? Check the forum!
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> 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