Re: Importing SQLServer Database into Oracle DB

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Wed, 08 Jan 2003 13:27:48 -0600
Message-ID: <fjuo1vo5ohk2iusq8ejgsvrtod33mvg0ov@4ax.com>

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) and use Oracle's Sql Loader to populate your tables..Any procedures, etc you have in SqlServer will most likely not work in Oracle so you will need to recode them..

"Chris France" <schris_at_free.fr> wrote:

>Hi all,
>I am trying to perform exportation of my SQL Server 2000 database to Oracle
>8 database.
>The DTS from Mircrosoft seems not to allow me to transfer data but only db
>structure ...
>I dont know Oracle enough yet to know if there is a tool into Oracle's
>package (never heard of it).
>Does any one knows a tool to transfert a DB from SQLServer to Oracle
>including data ?
>Thanks
>
Received on Wed Jan 08 2003 - 13:27:48 CST