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]
