Solved

Export image data from SQL Server to Oracle

Posted on 2010-08-16
5
319 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
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
sumit2906 earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now