Re: Porting data to SQL Server

Ben W wrote:

> I am coming from a SQL Server background, and am trying to find out how data
> can be pushed from an Oracle db to a SQL Server db.
>
> I have been trying to investigate Heterogeneous services, but this seems to
> be for Oracle to source queries from a non-Oracle db.
>
> Is there any such tool that can, on a scheduled basis, push specific (query
> based) data from an Oracle db to SQL Server.
>
> I am not in the position to use SQL DTS (pulling data from Oracle) as access
> privaleges are tight. I am only able to create relevant tables in my SQL
> Server db, and expect the data to be there. But the method in doing so is my
> job...
>
> Many thanks,
> Ben

Purchase Oracle's Transparent Gateway for SQL Server.

-- 
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)