Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle to Sql Server

RE: Oracle to Sql Server

From: Shaw, Donnie <>
Date: Thu, 30 Aug 2001 13:06:50 -0700
Message-ID: <>

On sql server table create your column definition as a TEXT column. But be aware of the 2g limitation.

-----Original Message-----
Sent: Thursday, August 30, 2001 11:06 AM To: Multiple recipients of list ORACLE-L

It's working . but how do I move those objects with CLOB Datatype ??  

Any Ideas???    

Easy. Use SQL*Server's DTS (data transformation services) to pull the data from Oracle into SQL*Server.  

Jon Walthour

-----Original Message-----

Sent: Thursday, August 30, 2001 12:07 PM To: Multiple recipients of list ORACLE-L

Hello Folks,  

I am looking for some cool script to move all the database objects across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently.  

Is there any particular way we can do it to automate this ??  

BTW: I want to pledge $20 or even willing to pay yearly subscription and it would be a good
idea to Send out a Pledge form to everyone . to keep the greens coming..  



This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.

Please see the official ORACLE-L FAQ:

Author: Shaw, Donnie

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 30 2001 - 15:06:50 CDT

Original text of this message