How do I bring an Oracle BLOB into SQL Server?

[Ascalonian]

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.

 

[bborissov]

Start Enterprise Manager and right click on database name.
From the context menu choose "All Task->Import data"
Follow the wizard.

If this is a one time job there is no need to create DTS. But if you need to run this regulary than DTS is your choice.

Unfortunately I have no 2000 here to point you how to create DTS package.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Ascalonian]

bborissov:

Thank you for your suggestion. I will try this out.