This utility helps you migrate all the tables from Oracle to SQL.

Things to be noted:
(1) USE this as the last option, in case if nothing else which is more RECOMMENDED like SQL Server Migration Assistant (SSMA) or Import Export Wizard works.

(2) Make sure that you have the database created on the SQL Server before you run this exe.

(3) Install the 32 bit version or 64 bit version depending on the Oracle provider being installed on the machine you're running it from.

(4) The log file for it would list down:
- All the tables which have been migrated successfully from Oracle to SQL.
- Tables which could not be migrated along with the query which was run on the SQL side to create a corresponding table and the exception occurred.

(5) This utility does the Data Type Mappings referencing the MSDN article https://msdn.microsoft.com/en-IN/library/ms151817.aspx

(6) All those data types on the Oracle side which did not have a corresponding SQL data type are converted to NVARCHAR(MAX) data type on the SQL side.

(7) Few tables which might fail during the migration process would be because they do not have any columns, i.e. a table with 0 columns which is not possible on the SQL Side.

Example:
Table Name: ORDDCM_PREFS_DEF_VALUES_TAB
Query used to create that table: use test ; create table ORDDCM_PREFS_DEF_VALUES_TAB)
Exception: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'.

(8) This tool just helps you migrate data after creating corresponding table on the SQL Server side and DOESN'T take care of any relationships or constraints between/among tables or columns.

When shall I use it?
As stated above, when nothing else works and you just want to make sure that the data is being moved somehow with the acceptance towards the standard data mappings.

Below are the 32 bit and 64-bit versions of the exe along with the entire project.
Hope it helps.

Last edited Sep 9, 2015 at 4:42 PM by dlak, version 7