Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: How to extract file stored in image type

    Hello,

    I had a problem.
    I need to transfert tables between from and SQl Server V7 to and Oracle 8I database.

    One of my MS-SQL table look like this:

    table mySQLtable(
    id int,
    filetype nvarchar(5),
    binaryfile image)

    My Oracle destination table is :

    table msOracletable(
    id number not null,
    filetype varchar2(64),
    bynaryfile blob)
    ;


    How can I extract datas from my SQL table, specially the binaryfile and
    import datas into my Oracle table ?

    Can somebody help me ?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Try using DTS to import/export data between SQL & Oracle.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Aug 2003
    Posts
    62
    I don't success using DTS because of image field.

    Is there a special way to do that ?

  4. #4
    Join Date
    Aug 2003
    Posts
    62
    I found a tool called TEXTCOPY to extract files from database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •