Re: oracle/ms sqlserver replicating

Joel Vannorsdel <Joel_Vannorsdel_at_bigfoot.com> wrote:

You can do this with just Oracle.

1. One way is to install Oracle's ODBC and copy tables with some MS SQL tool.
2. The other way is, to use the Oracle Open Client Adapter tool, with which you can copy tables to and from an ODBC data source.

Of course you can't copy everything. I don't know any tool with which you can translate database procedures, nor copy tablespaces, or rollback segments (:-) in SQL Server.

>Robert McArthur wrote:
 

>> Dwayne K. Lanclos (lanclosd_at_flash.net) wrote:
>> | In article <3394B329.68BCD8B6_at_epsilon.com>, Tim Smith
 <tsmith_at_epsilon.com> wrote:
>> | >What is the best way to move data back and forth between oracle and
 sql
>> | >server? I have an environment where the database update process
 runs on
>> | >a unix machine in oracle and the users want to do
 reporting/updating the
>> | >same database on an NT platform that already has sql server on it?
>> | >
>> | I've never tried replication between SQL Server and Oracle, but if
 they're
>> | both ODBC compliant, it is supposed to work. Don't know if you can
 pull from
>> | Oracle to SQL Server, however. Might want to check Books Online.
 

>> | ----
>> | dwayne lanclosd_at_flash.net
 

>> | "Experience is something you don't get until just after you need
>> it."
>>
>> We've done it several times now, and the volume of data transferred is
>>
>> the deciding factor. If the volume is low, you can write a simple
>> Delphi
>> program to do it (using the BatchMove widget). If the volume is high,
>>
>> try exporting text out of Oracle, then importing using the SQLS bulk
>> loader (the moral equivalent of SQL*Loader). With truly large daily
>> transfers -- say, >>100K records -- you'll probably find that it's
>> faster
>> to drop the SQLS indices and re-build them after each transfer.
>>
>> We couldn't find a way to patch an ODBC client into SQLS to make the
>> data
>> transfer happen directly with no intermediate. This may be possible,
>> though I doubt it.
>>
>> Bob
>> NetSiam Ltd., Bangkok
 

> Hetorgeneous replication is supported by the OmniReplicator product
>from Praxis International (www.praxisint.com) It can provide complete
>protection from collisions and good performance without any modification
>to the existing code. Also this requires no programming it is run by a
>GUI.
>Joel

You can do this with just Oracle.

1. One way is to install Oracle's ODBC and copy tables with some MS SQL tool.
2. The other way is, to use the Oracle Open Client Adapter tool, with which you can copy tables to and from an ODBC data source.

--
Eddy Orlowski
edorlow_at_xs4all.nl