Abstract: Based on the consideration that the current used Informix database software can not be maintained due to an enterprise merge, this paper proposes a method to migrate database from Informix to Oracle, which benefits improving the stability and performance of the database and expands the applications. This resolution consists of data and programs transformations and uses Oracle Migration Workbench(OMW), procedure and embedded SQL programming language technologies. Experimental results show that the migrated systems operate stably and efficiently to meet the need of business managers.

Key words: database migration, Oracle database, data migration, program transformation, stored procedure, performance optimization

摘要： Informix公司被收购后存在原有数据库升级维护困难的问题，为提高数据库性能与稳定性及满足公司信息系统集中的需要，提出一种从Informix向Oracle数据库迁移的方法，其包括数据迁移和程序转换，采用Oracle数据库迁移工具包、存储过程和嵌入式结构化查询语言编程技术。项目试运行结果表明，基于该方法迁移的应用系统运行稳定、处理高效，能满足业务管理人员需求。

关键词: 数据库迁移, 甲骨文数据库, 数据迁移, 程序转换, 存储过程, 性能优化

CLC Number: 

• TP311.56