Export image data from SQL Server to Oracle

Hi

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.

Thanks

Kelvin
LVL 23
Kelvin SparksAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sumit2906Commented:
did you tried OMWB (oracle migration workbench). check out this link for what oracle provides for migration:
http://www.oracle.com/technetwork/database/migration/index-084442.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kelvin SparksAuthor Commented:
Thanks,
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!
 
Kelvin
0
sumit2906Commented:
you can go to otn.oracle.com 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.
0
Kelvin SparksAuthor Commented:
I got as far as
http://www.oracle.com/technetwork/database/migration/sqlserver-083382.html.
 
Outline opens but not the content in the middle.
 
Kelvin
0
Kelvin SparksAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.