EMS Data Pump for SQL Server is an excellent utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access or any other database with ADO support) to Oracle databases.
Features: EMS Data Pump is a utility for converting databases and importing table data to Oracle. The source can be any ADO compatible database such as MS Access or any other database with ADO support. The application works in a wizard like fashion to make the conversion process very easy. You can easily build the ADO connection string, select tables, fields and indices for converting. You have the facilities to view and edit SQL script for generating target Microsoft SQL database and select tables for import. Source DBMS schemes are supported, as is Unicode characters there by facilitating multi-language databases. Data Pump for Oracle has the ability to automate migration to Oracle server task using the helpful console utility.
Converting of database structure and data from any SQL servers or local databases that have a ADO provider. You can create a new database or connect to an existing one with equal ease. When converting, you can be selective. You can choose not to convert the whole database but parts of it such as source table, fields and indices that you want. The generation of tables, fields, indices according to the source structure is quite quick. Target database objects options are easily customizable. Creating, editing and viewing of SQL script to create large databases is possible. The complete conversion process is easily monitored.
Overall: A handy utility for converting your legacy databases to Oracle easily and quickly.