How SQL Server 2005 exports data to Oracle 11g

The export is derived from the MS-brought OLE DB provider Access interface:

1. Right-click the database to Export "task"-"Export Data"-"Set export data source

2. Set Oracle as Target data source

3. Set the target table (create)

4. Edit Field

Since SQL Server's T-SQL is not the same as Oracle's pl/sql definition data type, note here to modify the type:

int-> Number (note the precision of setting number)

nvarchar-> varchar2 (preferably nvarchar2, but Ms this drive only offers this conversion)

DateTime-> Date

You can also edit SQL directly, note how Pl/sql is written, and the next step after editing

5. The datetime here is turned into date with a warning, but it doesn't matter, then you can ignore the error and truncation, and next:

6. Click Finish

View the data table and data just exported in Oracle EM