Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I bring an Oracle BLOB into SQL Server?

Status
Not open for further replies.
Ascalonian

Ascalonian

Programmer
Jan 4, 2008
264
US
If this is the wrong forum, please let me know.

I have two databases: Oracle 10G and SQL Server 2000.

Inside the Oracle database, I have several MS Word documents stored as BLOBs. What I need to do is extract the files from Oracle and place them into SQL Server. I am curious as to how I do this?

I have heard something about DTS but not sure if that is something to look into.

Thank you for your time.
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
146
tekpr00
tekpr00
petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
151
petart
petart
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
276
markjoseph1232
markjoseph1232
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
141
botatun
botatun
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
217
johnb1023
johnb1023

Part and Inventory Search

Sponsor

Back
Top