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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
