upgrade

1.检查数据库类型；

1.1. HSQLDB；

1.2. SQLAnywhere;

2. 检查HSQLDB数据库是否需要升级；

2.1. 需要升级HSQLDB数据库；

2.1.1. HSQLDB升级开始；

2.1.2. 数据迁移，在两个不同版本数据库文件之间；

2.1.3. 新旧数据库文件切换；

2.2. 不需要升级HSQLDB数据库；

3. 检查数据库脚本是否需要升级；

3.1. 需要升级脚本；

3.1.1. 脚本升级开始，备份旧的数据库文件；

3.1.2. 脚本升级，主要是连上数据库执行相关SQL；

3.1.3. 更新最新版本号至T_DBVersion表中;

3.2. 不需要升级脚本；

4.不需要升级/升级完成；

e文：

1.Check the database type;

1.1. HSQLDB;

1.2. SQLAnywhere;

2 .Check whether HSQLDB database need upgrade;

2.1 Need to upgrade HSQLDB database;

2.1.1. HSQLDB upgrade begin;

2.1.2 data migration between the two different versions of the database file;

2.1.3. Switch the old and the new database file;

2.2 Don't need to upgrade HSQLDB database;

3.Check whether database scripts need to upgrade;

3.1 Need to upgrade database script ;

3.1.1. database script upgrade begin,backup of the old database file;

3.1.2 upgrade database script, is connected to the database to perform SQL;

3.1.3 updated with the latest script version number to T_DBVersion table;

3.2 Don't need to upgrade database script;

4.Don't need to upgrade or upgrade is complete;

In Step 2.1.1:HSQLDB database upgrade process is terminates abnormally.due to missing 'template.script' or 'template.properties' file,

转载于:https://www.cnblogs.com/duanxz/archive/2012/11/28/2792755.html