Re: Oracle to SQL Server.

We would use Access to connect to the Oracle and the SQL Server and then use the worksheet to create the basic insert statement.

Thanks,
Bryan Lenihan

Aleksandr Shneyderman wrote:

> 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