database schema changes and versions

[gerardg]

If you change your database schema (such as renaming/dropping fields) from one program version to the next, is there an easy way to make data ex/im-porting easy? Or is it either:

a) Specify to users exactly what fields they need to export (what about renamed fields?).

b) Create scripts that use ALTER TABLE to change the database.

?

[[deleted]]

if you decide to change the database model for your app, you should write a tool that will convert your user's databases to the new model without them having to do anything.

users are stupid, they will f*ck up. 🙂

[gerardg]

Yeah - I think it'll save more time than my current update script ;-)

<?

rtfm();

?>

[[deleted]]

I like that script... slap a GNU on that and put it on sourceforge! 🙂