Oracle Migration Workbench

The Oracle Migration Workbench (OMW) is a handy tool for migrating data and database objects from other database engines to Oracle 9i or Oracle 10g databases. The OMW supports migrations from SQL Server 6.5, 7, and 2000 on Windows platforms, Microsoft Access 2.0, 95, 97, 2000, 2002, and 2003 on Windows platforms, Sybase Adaptive Server 11 and 12 on Windows and Linux platforms, Informix Dynamic Server 7.3, 9.1, 9.2, 9.3, and 9.4 on Windows and Linux platforms, MySQL 3.22, 3.23, and 4.X (or 5.0 with a special plug-in) on Windows and Linux platforms, IBM DB2/400 V4R3 and V4R5 on Windows platforms, and IBM DB2 UDB V6, V7.1, and V7.2 (Beta) on Windows platforms.

Of special note is the fact that the XML Exporter allows the simultaneous export of multiple Jet MDB files into either a single schema or multiple schemas. The OMW also supports migration of Jet queries to Oracle views.