Re: Migration from SQL Server to Oracle 8i

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Tue, 11 Jan 2000 06:35:58 GMT
Message-ID: <8EB89443dlm@206.141.192.241>

ajai_at_netscape.net (Ajai Khattri) wrote in <85d5oa$edb$1_at_nnrp1.deja.com>:

>Are there any tools available that can help migrate a database from SQL
>Server to Oracle 8i?

i believe you want to look at ETL (extract-transform-load) tools. they all permit you to make connections to old and new databases, change datatypes (or make other corrections of past sins), and transfer schema and data.

the poor-man's method is to bring up both databases and use an ODBC connection to the remote database to push or pull the data. for example you could use the sql*plus COPY command, and so avoid unloading the data to flat files.
--
dave mausner Received on Tue Jan 11 2000 - 00:35:58 CST