List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:August 8 2008 6:00pm
Subject:RE: Transplanting table structure changes
View as plain text  
>-----Original Message-----
>From: Martijn Tonies [mailto:m.tonies@stripped]
>Sent: Thursday, August 07, 2008 1:46 AM
>To: mysql@stripped
>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/mysql?unsub=1
>infoshop.com




Thread
Transplanting table structure changesJerry Schwartz6 Aug
  • Re: Transplanting table structure changesGlyn Astill6 Aug
  • Re: Transplanting table structure changesMartijn Tonies7 Aug
    • RE: Transplanting table structure changesJerry Schwartz8 Aug
    • RE: Transplanting table structure changesJerry Schwartz8 Aug
  • Re: Transplanting table structure changesMarkus Grossrieder10 Aug
    • RE: Transplanting table structure changesJerry Schwartz11 Aug
  • Re: Transplanting table structure changesMartijn Tonies11 Aug