Replicating Oracle DB Tables to SQL Server 2000 DB

From: Jeremy <jcapp_at_belzon.com>
Date: 26 Jan 2004 09:19:40 -0800
Message-ID: <7ae3f23b.0401260919.7e34667b@posting.google.com>

Greetings,

I am hoping someone can help and lead me in the correct direction on a situation my company's facing.

We run and support MSSQL 2000. We have a project that requires access to data that is being collected from all over the US, but this data is all collected in an Oracle database. This Oracle database is not on our network.

One of our options would be to purchase Oracle and hire a full-time Oracle DBA. Not the option we want unless we absolutely have to.

So, what needs to be done to sync up or replicate the tables (on a nightly basis) that are in Oracle to our MSSQL 2000 database?

How is the issue of different data types (ie: converting number to int) handled?

Thanks in advance,
Jeremy Received on Mon Jan 26 2004 - 11:19:40 CST