0.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-Original Message-
>From: Markus Grossrieder [mailto:[EMAIL PROTECTED]
>Sent: Sunday, August 10, 2008 8:46 AM
>To: Jerry Schwartz; mysql@lists.mysql.com
>Subject: Re: Transplanting table structure changes
Hello Jerry,
> >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] Ah! I just discovered that if I hit what looks like
riginal Message -
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
To: "'Martijn Tonies'" <[EMAIL PROTECTED]>;
Sent: Friday, August 08, 2008 8:44 PM
Subject: RE: Transplanting table structure changes
>You might want to try our Schema Compare tool insid
>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] Ah! I just discovered that if I hit what looks like the "record"
button, I get
>-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 colu
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 PHPMyAdmi
Sutput the table definitions and cut and paste the new columns into a ALTER
TABLE table_name ADD column_name column-definition statement.
--- On Wed, 6/8/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> From: Jerry Schwartz <[EMAIL PROTECTED]>
> Subject: Transplanting table structure changes
> T
