| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle to Sql Server
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..
Cheers
RK
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: http://www.orafaq.com
--
Author: Shaw, Donnie
INET: dshaw_at_acsalaska.com
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: ListGuru_at_fatcity.com (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
 |
 |