Hello

I'm developing an application and a client is currently running the beta
(alpha) release. In the meantime, I'm continuing to develop the applciation
and (slightly) changing the database structure. What's the best way off
making those database changes to the client's database whilst retaining
their data?

I've thought of comparing the two database structures and creating an SQL
script containing a lot of ALTER statements (time consuming) or writing an
application to extract their current data and pump it into a new database.
Can any of these two options be automated?

I would have thought that this is a common problem, what's the standard
answer? ;-)

Thanks

David