Roll up changes per table

Description

Transferred from Sourceforge:
artifact_id: 1949123
submitted_by: dmisheewk
assigned_to: nobody
priority: 5
resolution: None
open_date: 1208894708
aftifact_type: Feature Requests
category: Migrator Core
artifact_group_id: None
category: Migrator Core
status: Open
history: N/A
messages: N/A

I have a large MySQL database and I often want to "rollup" changes into single SQL statements per table if possible.

For example:

In development,

changeset 1 = alter bigtable add column ...
changeset 2 = alter smalltable add column ...
changeset 3 = alter bigtable add column ...

When it is time to upgrade the production system, I would want changesets 1 & 3 to be consolidated into one SQL command. MySQL is slow in updating large tables because it must work on a copy first. I can take the hit once to add 2 new columns in one SQL statement, or take twice as long to update the table using 2 SQL statements.

When the upgrade time for bigtable runs several hours, I really need to consolidate where possible!

So far, I do this manually, but "manual operations" are always error prone...

Environment

None

Status

Assignee

Unassigned

Reporter

dmisheewk

Labels

None

Components

Fix versions

Priority

Trivial