We have two servers: one for the developer (me) and one for the tester.
While working on the app, I sometimes make little changes in tables's schemas. (Like a new field, or a field type)
I'm trying to find a way to update the TEST's schema from the DEV without altering the TEST data.
I tried to dump the DEV structure only, execute it on the
TEST db, and then fill it with the TEST data. But the new
schema is replaced with the old
Do you have a way to do that ? Or will my tester be forced to fill the database everytime we update?