设为首页收藏本站我的广告

运维网

 找回密码
 注册

QQ登录

只需一步,快速开始

扫一扫,访问微社区

搜索
总共321条微博

每日一博

查看: 559|回复: 0

[更新动态] 【站长推荐】Ora2pg 16.0 发布,Oracle 转 PostgreSQL 工具【顶】

[复制链接]

该用户从未签到

sun 发表于 2015-10-17 22:26:37 | 显示全部楼层 |阅读模式
【重大新闻】 Ora2pg 可以用来将 Oracle 数据库转换成 PostgreSQL。
Ora2pg 16.0 发布,此版本主要改进了 PL/SQL 代码替换,修复了一些 bug,添加了一些新特性:

  • Full migration of MySQL database, it just work like with Oracle database.
  • Full migration assessment report for MySQL database.
  • New script, ora2pg_scanner, to perform a migration assessment of all Oracle and MySQL instances on a network.
  • Add technical difficulty level in migration assessment.
  • Allow migration assessment on client queries extracted from AUDIT_TRAIL (oracle) or general_log table (mysql).
  • Ora2Pg has a "made in one night" brand new Web site (still need some work) http://ora2pg.darold.net/
其他新特性:

  • Export type SHOW_TABLE now shows additional information about table type (FOREIGN, EXTERNAL or PARTITIONED with the number of partition).
  • Connection's user and password can be passed through environment variables ORA2PG_USER and ORA2PG_PASSWD to avoid setting them at ora2pg command line.
  • Improve PL/SQL replacement on ADD_MONTH(), ADD_YEAR(), TRUNC(), INSTR() and remove the replacement limitation on DECODE().
  • Add detection of migration difficulties in views, was previously reserved to functions, procedures, packages and triggers.
  • Replace values in auto generated configuration file from command line options -s, -n, -u and -p when --init_project is used.
  • Adjust lot of scores following new functionalities in Ora2Pg, ex: autonomous transactions, dblink or synomyms are now more easy to migrate.
为 ora2pg 脚本增加新选项:

  • -m | --mysql : to be used with --init_project and -i option to inform ora2pg that we work with a MySQL format
  • -T | --temp_dir : option to be able to set a distinct temporary directory to run ora2pg in parallel.
  • --audit_user : option to set the user used in audit filter and enable migration assessment report on queries from AUDIT_TRAIL (oracle) or general_log table (mysql).
  • --dump_as_sheet and --print_header options to be able to compute a CSV file with all migration assessment from a list of oracle database.
  • --dump_as_csv option to report assessments into a csv file. It will not include comments or details, just objects names, numbers and cost.
非向后兼容改进:

  • Change NULL_EQUAL_EMPTY to be disabled by default to force change in the application instead of transforming the PL/SQL.
新配置指令

  • MYSQL_PIPES_AS_CONCAT: Enable it if double pipe and double ampersand (|| and &&) should not be taken as equivalent to OR and AND.
  • MYSQL_INTERNAL_EXTRACT_FORMAT: Enable it if you want EXTRACT() replacement to use the internal format returned as an integer.
  • AUDIT_USER: Set the comma separated list of user name that must be used to filter from the DBA_AUDIT_TRAIL or general_log tables.
  • REPLACE_ZERO_DATE: the "zero" date: 0000-00-00 00:00:00 is replaced by a NULL by default, use it to use the date of your choice. Useful when you have a NOT NULL constraint.
  • INDEXES_RENAMING: force renaming of all indexes using a name with tablename_columnsnames. Useful for database that have multiple time the same index name or that use the same name than a table.
  • HUMAN_DAYS_LIMIT: default to 5 days, used to set the number of human-days limit for migration of type C.
更多内容请看:

源自:开源中国
运维网 感谢您的阅读
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|申请友链|sitemap|手机版|小黑屋|Archiver|运维网 ( 京ICP备16008201号  

GMT+8, 2016-12-9 19:30 , Processed in 0.043315 second(s), 34 queries , Xcache On.

Powered by Discuz! X3.2 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表