Migrating from Oracle to SQL Server

• Lino-149448

  Grasshopper

  Points: 21

  More actions

  June 8, 2004 at 1:02 pm

  #59713

  I've been trying to migrate from Oracle 8i to SQL Server, but I've been getting "Unspecified Error" on a DTS import.  I believe they are generated from a column that is a clob.  Is there a way to migrate clobs to SQL Server?

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  June 9, 2004 at 6:07 am

  #509621

  I think that you have an OLEDB problem. As far as I remember the Microsoft OLEDB driver does not support Oracle 8 CLOB data types.

  Try searching on OLEDB supported data types? Hope it helps.

  
  Andy.