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/p/2792755.html