Porting MS SQL Server 2000/2005/2008 database to Oracle 9i/10g/11gThis article describing how to use ESF Database Migration Toolkit to porting data from MS SQL Server databaseto Oracle database in 3 simple steps without writing any SQL Script!
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 "SQL Server (Standard)" or "SQL Server (Windows Authentication)" as the source database type. Put the correctly logon information(server, port, username, password). You can enumerate all MS SQL Server databases and schemas automation by press "Refresh" button. Selecting the database wich will be migrated to Oracle database, then click "Next" to continue.
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, SERVICE_NAME or TNS method), it depends on Oracle configuration. Put the Oracle instance name(SID) or database name(SERVICE_NAME) in "Database" box, put an new schema or select an exists schename(it is same as the username usually).
Click "Next" to continue.
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 migration. You can only migrate the source table structure via checking "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, please let this field empty or 1=1) to telling program which records will be migrated. Click "OK" to save your settings.
5). In "Execution" page, click "Submit" to starting MS SQL Server to Oracle migration.
If you have any questions or suggestions, please contact us. Thank you for your time!