IBM MTK数据库迁移工具

IBM Migration Toolkit release notes Version MTK 2.0.5.1 1.0 Release notes - MTK 2.0.5.1 Release 2.0.5.1 of the IBM® Migration Toolkit (MTK) is now available. Compatibility, installation, and other getting-started issues are addressed here. Contents * "Description of MTK" * "What is new for MTK 2.0.5.1" * "Product fix history" * Compatibility issues with earlier versions * "Hardware requirements" * "Software requirements" * "Installing MTK 2.0.5.1" * "Known problems" Description of MTK MTK is designed to migrate data, query and procedure language, and database definitions from the source database management systems to the target systems. MTK can be run from a variety of database platforms. Here are the supported source and target combinations: +---------+-----------------------------------------------------------+ | | Source DBMS | +---------+---------+---------+---------+---------+---------+---------+ | Target | | Oracle | Sybase | Sybase | Microso | MySQL | | DBMS | | Version | Adaptiv | SQL | ft® SQL | Version | | | | s 8i, | e | Anywher | Server | s 4 and | | | | 9i, and | Server | e (ASA) | 2000 | 5 | | | | 10g | Enterpr | Version | and | | | | | | ise | 9 | 2005 | | | | | | (ASE) | | | | | | | | Version | | | | | | | | s 11, | | | | | | | | 12, | | | | | | | | 12.5 | | | | | | | | and 15 | | | | | |---------|---------|---------|---------|---------|---------| | | DB2® | X | X | X | X | X | | | Databas | | | | | | | | e for | | | | | | | | Linux®, | | | | | | | | UNIX®, | | | | | | | | and | | | | | | | | Windows | | | | | | | | ® - | | | | | | | | Version | | | | | | | | s 9.1, | | | | | | | | 9.5 and | | | | | | | | 9.7 | | | | | | | |---------|---------|---------|---------|---------|---------| | | DB2 for | X | X | - | X | X | | | i5/OS® | | | | | | | | V5R2,V5 | | | | | | | | R3 and | | | | | | | | V5R4 | | | | | | | |---------|---------|---------|---------|---------|---------| | | DB2 for | X | - | - | - | - | | | z/OS® | | | | | | | | Version | | | | | | | | s 8 | | | | | | | |---------|---------|---------|---------|---------|---------| | | DB2 for | X | X | - | - | - | | | z/OS | | | | | | | | Version | | | | | | | | s 9 | | | | | | | |---------|---------|---------|---------|---------|---------| | | Informi | X | - | X | - | X | | | x® | | | | | | | | Dynamic | | | | | | | | Server | | | | | | | | Version | | | | | | | | s 10 | | | | | | | |---------|---------|---------|---------|---------|---------| | | Informi | X | - | X | X | X | | | x | | | | | | | | Dynamic | | | | | | | | Server | | | | | | | | Version | | | | | | | | s 11.10 | | | | | | +---------+---------+---------+---------+---------+---------+---------+ What is new for MTK 2.0.5.1 Release 2.0.5.1 includes the following new and changed features: * Support for migrations to DB2 Version 9.7 for Linux, UNIX, and Windows. Restriction: MTK does not support DB2 Version 9.7 for Linux, UNIX, and Windows with compatibility features. Product fix history Here is a description of the defects that were fixed in this version: * The mapping type that is selected from the global type mapping panel is not used by the translator for binary and long binary data types (Sybase SQL Anywhere (ASA) to Informix Dynamic Server). * A PARSEINT error in db2property.java during deployment. * The MTK GUI allows invalid Generate Data Transfer Script options to be specified for z/OS targets. * The pop-up help on the Convert page is specific to DB2 targets. * The error with the Microsoft SQL Server to Informix Dynamic Server translator runtime month/year/date value. * In conversions from Oracle to DB2 for z/OS, Version 9, the NUMBER type columns cause a runtime exception. * After a migration from Oracle to DB2, poor runtime performance is observed in the TO_CHAR routines. * An unsigned double type with a default value causes an exception at run time. * Global type mapping is not visible in the MTK GUI for migrations to DB2 Version 9.5 for Linux, UNIX, and Windows. * The MTK wizard shows that the deployment has failed even when all of the objects are deployed. * In conversions from Oracle to DB2 for z/OS, Version 9, declaring a DECIMAL(p,s) column in Oracle source database causes an exception at run time. * In conversions from Oracle to DB2, the Oracle NCHAR is not mapped to DB2 CHAR. * In conversions from any source database to target DB2 for z/OS, MTK truncates the index and trigger names to 18 characters. * In conversions from any source database to target DB2 for z/OS, MTK truncates constraint names to 18 characters. * In conversions from MySQL to DB2, columns that contain both the BIGINT data type and the NOT NULL constraint cause a run time exception. * Excessive amounts of memory are used when deploying to Informix Dynamic Server by using JDBC resulting in out-of-memory and heap dump files. * Informix Dynamic Server connection error during deployment. * In conversions from Microsoft SQL Server to Informix Dynamic Server, deployment hangs when CLOB or BLOB data types are present. * Informix Dynamic Server deployment fails to connect. * Data files are not being overwritten during source data extraction. * Oracle LOBs are put in the wrong directory and are not loaded during data deployment. * The database name from the CLI configuration file is ignored. * Case sensitivity errors on deployment of the Microsoft SQL Server UDF.