| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Sql Server to Oracle interface
On Mon, 17 Aug 1998 10:11:13 -0700, Doug Chernoff <dougc_at_bcaa.bc.ca>
wrote:
>Hello,
> Does anyone know of a way of interfacing directly between Sq1
>Server 6.5 and Oracle 7.3. I'm trying to move data from Sql Server to
>an Oracle database, without creating an intermediate C program.
>
>The Sql Server documentation has something called "ODBC Drivers for SQL
>Server and Open Data Services". This sounds like something that might
>allow a direct connection between the two databases using ODBC as an
>interface. Has anyone used this?
>I'd appreciate any insight anyone might have into this.
>
If you need to do this repeatedly and maybe in a batch environment, then you could look at putting in one of Oracle's transparent gateways for SQL Server. The good thing about this is that the "remote" SQL Server database will appear as if it were a remote Oracle database. Once you do this, you can exploit any of the features in a distributed Oracle environment (database links, replication, etc.). Check out: http://www.oracle.com/products/gateways/html/transparent/tgmsss.html
If you need to do this only once, you could use some tool like MS Access or PowerBuilder to shift the data over. In a previous life, I used PowerBuilder's Data Pipeline (or something like that) which made it very easy to connect to two dissimilar databases, and move database structure and data between the two.
>Thanks for any assistance.
>
>
>
Thanks!
Joel
Joel R. Kallman Oracle Government, Education, & Health
Columbus, OH http://govt.us.oracle.com jkallman@us.oracle.com http://www.oracle.com
 |
 |