>-----Original Message----- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 07, 2008 1:46 AM >To: mysql@lists.mysql.com >Subject: Re: Transplanting table structure changes > >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. > [JS] I'm looking at the trial version of Database Workbench right now. I'm not sure exactly how to use the output of the schema compare tool for my purposes. I've already made the changes to the test environment, with a lot of trial and error, so there is no script to record. > >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]
