Re: Importing SQLServer Database into Oracle DB

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 8 Jan 2003 12:04:47 -0800
Message-ID: <3e1c845f@news.victoria.tc.ca>

TurkBear (john.greco_at_dot.state.mn.us) wrote:

: If you search these newsgroups you will find many,many answers to this..
: Look into the Oracle Migration Workbench( http://technet.oracle.com
register, its free), but be aware that the concepts, : methodology and architecture of an Oracle RDBMS are quite different from those in SqlServer, so you will probably want to : create the tables you need in Oracle, export the data for those tables from SqlServer as CSV file(s)

If practical, I suggest fixed width fields in the file, not csv. Using sql loader with fixed width input is trivial. Leave a space between fields to make the file easy to read with an editor if necessary. Received on Wed Jan 08 2003 - 14:04:47 CST