Re: Replicating Oracle DB Tables to SQL Server 2000 DB

Jeremy wrote:

> 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

Push the data to your system via Oracle's Transparent Gateway ... now renamed (what isn't) to heterogenous services.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)