Migrating data to Oracle 8i, 9i, 10g, 11g from others database formatsOracle is a very popular DBMS(Database Management System) in the world. This article describing how to use ESF Database Migration Toolkit to migrate data from others database formats to Oracle database in 3 simple steps!
Introduction:First of all, if you have not installed ESF Database Migration Toolkit, get it now.
1). After start program, press "Next" button. In "Choose a Data Source" dialog, choose the source database type, e.g. MySQL, MS SQL Server, IBM DB2, PostgreSQL, Teradata, MS Access, Firebird etc. Put the correctly logon information. For MySQL, PostgreSQL, SQL Server, Teradata, IBM DB2: server, port, username, password. You can enumerate all source databases or schemas automation by press "Refresh" button
For MS Access, MS Excel, Foxpro etc: press "Browse" to select the source database file or folder(Foxpro).
2). In "Choose a Data Destination" dialog, choose "Oracle Database ", put the correctly logon information: Server(host_or_ip_address), Port(e.g. 1521), Username(e.g. system), Password. Choose a connect method(SID or Service_name), it depends on Oracle configuration(defined in tnsname.ora). Input the Oracle instance name(SID) or database name(Service_name), input an new schema or select an exists schename.
3). In "Select source Tables(s) & View(s)" dialog, it is listing all the tables and views in the source database. You can preview source table data via "Preview" button. Selecting the table(s) or view(s) that you are preparing to migrate to Oracle. In here, you have a chance to change the destination table name at "Destination" column. There is an "Overwrite Database" option below the list (Notice: When you check this option, the destination database will be removed, and all data will lose!). If you want to set more options for migration, click "..." button at "Transform" column immediately.
4). In "Transform" dialog, there are some useful options for Oracle migration. You can only migrate the source table structure via check "Copy Structure Only" option or other's options in migrating. You can change the target Oracle field name, data type, default value in "Field Map". Plus, give a data filter (e.g.: id<100 etc) in "Records Filter (WHERE)" option (If you want to migrate all data let this field empty or 1=1) to tell program which records will be migrated. Click "OK" to save your settings.
5). In "Execution" page, click "Submit" to starting the Oracle migration.
If you have any questions or suggestions, please contact us. Thank you for your time!