Is the database upgrade process destructive?
The Movable Type upgrade process will automatically make any changes to your database, both in structure and in its content, to properly move you from one version to any other version. The core application as a rule never removes tables or columns from the system. In fact, the database driver prevent columns and tables to be dropped at all. So the schema may be augmented or modified, but never destroyed.