Re: Oracle7 to SQL*Server

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Wed, 10 Jun 1998 20:11:15 -0400
Message-ID: <6ln7fp$dik@sjx-ixn2.ix.netcom.com>

You can do it in the following ways
1. Simply get the data out from Oracle to flat files (you can use sqlplus spool command or use tools that can extract data) and use BCP to load the data into SQL Server. 2. Use the Oracle transparent gateway for MS SQL Server. This is probably the best option but also the MOST expensive.
3. Use a tool (I have used SQL Mover) that can map/transfer data between two disparate data sources.
4. For small scale data transfers you can use MS-Access. Import data into Access and then transfer data to SQL Server using linked tables.

I hope you have relatively similar table structures in both databases, otherwise it can get a bit hairy.

Good luck
Venkat

>We need to Update a SQL*Server database from an Oracle7 database?
>
>Any Ideas? We just installed our first SQl*Server db (obviously do not know
>much about it)
>
Received on Wed Jun 10 1998 - 19:11:15 CDT