From: Martijn Tonies
Date: August 7 2008 5:45am
Subject: Re: Transplanting table structure changes
List-Archive: http://lists.mysql.com/mysql/214000
Message-Id: <000f01c8f850$d90ae0a0$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello Jerry,

> I've added about a dozen new columns to two tables in my development
> environment, and now I need to roll it out to our production environment.
> Can anyone suggest an easy way to do this? I want to avoid typos, as much
as
> I can.
>
>
>
> I made the original changes with PHPMyAdmin, so I don't have any original
> script to re-use. The best idea I've come up with is to capture the output
> of SHOW CREATE TABLE and massage that, but I wonder if I'm missing
> something.

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.


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