Presently i'm on a project that involves the migration of database from Oracle server to SQl server. Can i directly access the Oracle database from Sql server? How do i setup the ODBC drivers to connect to an Oracle server?Thanks.

-- Anonymous, January 18, 2000

Answers

Gilbert,

There are several ways to move data from Oracle to SQL Server 6.5.

You could install SQL Server 7.0 on another machine and use DTS to move data from Oracle to your 6.5 server.

You could use a Data Modeling tool such as ERwin.

You could use tools like Data Junction (http://www.datajunction.com), SQL Mover (http://www.sqlmover.com), and InfoPump (http://www.platinum.com).

You could use the free utility, Oracle Migration Workbench (http://www.oracle.com).

Hope this helps,

Eric

-- Anonymous, January 18, 2000