> 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
> 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
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.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!