Re: oracle/ms sqlserver replicating

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 Received on Wed Jun 25 1997 - 00:00:00 CEST