I've been tasked with migrating data from an Oracle 11g instance on one domain with partial trust(one way trust, not two way) to a SQL Server.

I can query and tnsping the source Oracle 11g instance with no problems. When I try to use the SSMS import wizard, it cannot recognize the number data type. Whomever set up the Oracle tables used this data type hundreds of times.

Is there some way I can have SSMS recognize the data type and map it to Numeric?

  • Please post CREATE TABLE statement, sqlplus describe results, and/or DBMS_METADATA.GET_DDL – Michael Kutz May 19 at 20:15
  • What do you mean by "cannot recognize"? NUMBER is basically the one and only numeric data type in Oracle, so I would be very surprised if SSMS were unable to work with it somehow. – mustaccio May 19 at 20:24