Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Export image data from SQL Server to Oracle

Posted on 2010-08-16
5
Medium Priority
?
377 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:Kelvin Sparks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
sumit2906 earned 1500 total points
ID: 33452187
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
 
LVL 22

Author Comment

by:Kelvin Sparks
ID: 33452405
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
 
LVL 7

Expert Comment

by:sumit2906
ID: 33452470
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
 
LVL 22

Author Comment

by:Kelvin Sparks
ID: 33452479
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
 
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.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

670 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