Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to migrate mssql 6.5 to oracle 7.3.2

Re: How to migrate mssql 6.5 to oracle 7.3.2

From: Winxxniw <winxxniw_at_aol.com>
Date: 1998/01/31
Message-ID: <19980131032301.WAA05285@ladder02.news.aol.com>#1/1

Use bcp to unload the data, and SQL*Load to load it in. If your bcp data contains imbedded newlines, you'll need to use othe delimiters and convert them before inserting into Oracle via sqkl*loader. I've done this going from Sybase 10 to Oracle 7.3.3 Received on Sat Jan 31 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US