Re: Generating ALTER TABLE code for MySQL

in reply to Generating ALTER TABLE code for MySQL

I have two databases, one for development and another for production. They do not share the same data. When I make structural changes in development, I need to apply them to production when I update.

You might want to look at mysqldiff and SQLFairy.

Comment on Re: Generating ALTER TABLE code for MySQL

Replies are listed 'Best First'.
Re^2: Generating ALTER TABLE code for MySQL by soonix (Chancellor) on May 28, 2018 at 09:03 UTC
Link rot: twelve years later, SQLFairy still has the old URL, however, mysqldiff seems to live now here (and on github).	[reply]

In Section Seekers of Perl Wisdom