Post reply

Oracle blob migration to sqlserver using DTS

  • September 23, 2004 at 1:53 pm

    #162221

    hi,

    I am having blob/clob contents in my oracle database and wants to migrate to sqlserver using DTS. I am using sqlserver 200 with SP3. Please let me know, how can i do this.

    rgds,

    venkat

     

     

  • September 26, 2004 at 10:59 pm

    #524446

    Firstly, this is a wrong group. I thought you were talking about SQL2005. Anyways, BLOB's in Oracle map to SQL Server's TEXT,NTEXT or VARBINARY datatypes. Hence you can use DTS to directly do the migration.

    Vinod Kumar

    http://www.ExtremeExperts.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply