I use phpMyAdmin to do all my database work.  One of it's features is that for every operation it gives you the SQL statement.  When I'm making changes to the database during development, I save up these SQL statements in a file to I can repeat them on the live server during deployment.

One thing that isn't repeatable/scriptable is working with the foreign key constraints.  phpMyAdmin doesn't give the constraints a name so they are dynamically generated by the server.  That's no good if you want to script drops/changes to them.  I just took 10 minutes to modify phpMyAdmin so it gives the constraints a consistent name.

It's going to save me tons of deployment time (I've been doing the constraint changes manually).

And, yes, I'm working on a Saturday.. ;(

Why should a communist work???

Sounds like something I would do.  ;-)

I don't think it's so much FOSS SW sucks as much as we programmers want to kick the DBA out of the way and do everything ourselves.  We are programmers, not para-IT/business hacks.  ;-D

"Why should a communist work???"

I'm not a communist.  ;)

+1 phpMyAdmin

Ooo..  I just fixed a bug in phpMyAdmin!

what?

hurray for the OP!

open source software rocks. it has bugs we can fix and feel good about.

>> Why should a communist work???

Err, because that's a fundamental principle of communism?

So let me get this straight... oss rocks because you modified phpmyadmin to do something MSSQL does out of the box?