Re: How to manage the versions of databases ?
Date: Fri, 09 Feb 2001 20:19:37 GMT
Message-ID: <3a8450ea.18143478_at_news.gte.net>
On Fri, 9 Feb 2001 17:20:59 +0000 (UTC), nicolas.ecarnot_at_bigfoot.com
(Nicolas Ecarnot) wrote:
>So may you give us some URL pointers to web pages explaining how it's
>usually done, or explain us the theory of updating a database model.
It's ... tough. But you already know that!
Basically, you can try to modify data and tables in place, or you can try to migrate data from the old data model to the new one.
The data migration is probably somewhat "cleaner", but also more disruptive, probably requires longer system downtime and, of course, generally 2x the disk space.
You also have the problem of backwards compatibility with applications, and/or versioning your stored procedures and views.
J. Received on Fri Feb 09 2001 - 21:19:37 CET