From oracle-l-bounce@freelists.org Tue Dec 7 06:41:47 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB7CflF01353 for ; Tue, 7 Dec 2004 06:41:47 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iB7Cflm01348 for ; Tue, 7 Dec 2004 06:41:47 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6EB1272CD67; Tue, 7 Dec 2004 07:48:11 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12380-96; Tue, 7 Dec 2004 07:48:11 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F1AC72CD0E; Tue, 7 Dec 2004 07:48:10 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: RE: Migration from MSSQL to Oracle Date: Tue, 7 Dec 2004 18:15:04 +0530 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Migration from MSSQL to Oracle Thread-Index: AcTbx/Dq6kOFLF7MTROC4LuMKuVWdgAkDaPAAACXGAA= From: "VIVEK_SHARMA" To: X-OriginalArrivalTime: 07 Dec 2004 12:45:04.0054 (UTC) FILETIME=[92C18560:01C4DC5A] X-archive-position: 13221 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: VIVEK_SHARMA@infosys.com Precedence: normal Reply-To: VIVEK_SHARMA@infosys.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org We will migrate to Oracle 9.2 or 10g as advised by the List? -----Original Message----- From: VIVEK_SHARMA=20 Sent: Tuesday, December 07, 2004 6:05 PM To: oracle-l@freelists.org Subject: Migration from MSSQL to Oracle How is the NTEXT Datatype column in MSSQL to be migrated to Oracle?=20 Any advice, tools, utilities, freeware, docs, links on the same & migration in general of the database from MSSQL on windows to Oracle on Linux? INFO:- ---- There only exists English data characters values in this field of the table This database is accessed over the internet by customers.=20 We can probably bring down the database for a MAX of 1 hour Database size is only 3 GB Any precautions? I shall provide any clarifications Thanks in advance -- http://www.freelists.org/webpage/oracle-l