Re: Oracle to SQL Server.

From: Aleksandr Shneyderman <ashneyde_at_bdsinc.com>
Date: 1998/02/05
Message-ID: <34D9DA80.CCDFC2ED@bdsinc.com>#1/1

Create tables in SQL Server and set up a dblink (CREATE DBLINK) to your SQL Server database in the Oracle database. Then with simple statements

    INSERT INTO @<your dblink>.<your table in SQL Server>      (........)
    SELECT .......
    FROM <your table in Oracle>
pipe your data from oracle to SQL Server for every table you want to copy to SQL Server.

If there are only few tables this is not hard. To set up dblink is a pain but fun experience.

Greg Parsons wrote:

> Hello,
> We're looking for a way to move a few tables from Oracle into SQL
> Server. What tools are available?
> Any help would be appreciated.
> Thank you. Greg
Received on Thu Feb 05 1998 - 00:00:00 CST