Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    6

    Unanswered: Migration from Sybase to Oracle

    Does anyone have experience migrating data from Sybase to Oracle using bcp and SQL Loader? I can migrate text data without any problems using bcp character format. I can also migrate image data using bcp native format. The problem is when I need to have text data and image data in the same export files. I can't have the text readable and the images in RAW format so they can be loaded by SQL Loader.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Perhaps you'd want to check Oracle Migration Workbench; on that page, you'll find a link to Oracle SQL Developer GUI utility which incorporates migration workbench for several databases, including Sybase.

    I didn't do it, but you might read through the documentation and see whether it offers an easy (easier) way to migrate your data than by using SQL*Loader.

Posting Permissions

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