Oracle to SQL

• ramu.guggilla

  SSC Eights!

  Points: 829

  More actions

  August 28, 2008 at 10:17 pm

  #131003

  hi folks,

  i am migrating the database from Oracle to sql server 2005. I tried to move the data using the SSMS import data from the oracle database. it is working fine. but when i am trying the RDP (Remote Desktop) i am getting the error "Opening a row set for "ECHTB_MEAS_DEF" (Table) failed. that table having the data type BLOB for one column.

  please suggest me how to over come this problem.

  - Ramu

• shripati-659987

  SSC Veteran

  Points: 273

  More actions

  August 29, 2008 at 1:15 am

  #864849

  Hi,

  There are some Oracle datatypes which are not supported in SQL eg Varchar without size specified in oracle will create problem in SQL 2005.

  You can also try a free tool SSMA to convert from Oracle to SQL.

  Shree