Re: oracle/ms sqlserver replicating

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 Received on Tue Jul 01 1997 - 00:00:00 CEST