Export image data from SQL Server to Oracle

Posted on 2010-08-16
Last Modified: 2012-05-10

I have a number of tables in SQL Server (can be 2005 or 2008) that need to have the data migrated to Oracle (10 or 11). There are images stored in these or large data files full of html code. The target Oracle tables have CLOB datatypes for the incoming data.

SQL scripts are not working. Oracle dmp files are used once the data needs to be moved into other Oracle databases. I cannot find a way to create a dmp file from SQL Server.

Does anyone know the correct way to do this initial transfer.


Question by:Kelvin Sparks
  • 3
  • 2

Accepted Solution

sumit2906 earned 500 total points
ID: 33452187
did you tried OMWB (oracle migration workbench). check out this link for what oracle provides for migration:
LVL 22

Author Comment

by:Kelvin Sparks
ID: 33452405
Having trouble getting some of these links to Open. I did generate a script using SQL Developer connected to SQL Server. Then ran the generated script to INSERT the data - it failed!

Expert Comment

ID: 33452470
you can go to and then navigate to download page, if this link does not work. what is the error you are getting, I will suggest you to first go through the documents and make sure it is supporting the datatypes you are trying to migrate.
LVL 22

Author Comment

by:Kelvin Sparks
ID: 33452479
I got as far as
Outline opens but not the content in the middle.
LVL 22

Author Closing Comment

by:Kelvin Sparks
ID: 33473652
Didn't really solve it, but I nutted my way through. Your comments did help refine my thinking. Had to disbale a few contraints before it would work.

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question