Re: sql server transparent gateway

prunoki wrote:

> Hello,
>
> Any of you using transparent gateway for microsoft sql server? I would
> be interested in your experiences. Would you recommend using it to
> migrate data from sql server to Oracle? We have an application
> developed for SQL Server which we would like to migrate to Oracle and I
> am looking for a way to get the schema and the data over to an Oracle
> 10 database. Triggers and stored procedures will be moved by hand and
> tailored individually.
>
> Cheers,
>
> Krisztian
>

What platform and version is your Oracle db on? The TG4MSSQL is currently only available for Windows platform. I have recently installed TG4MSSQL on a Windows 2003 server and the listener/instance configured to point to Oracle on Solaris with SQL Server 2000 on another Windows2K server.

Gets report data once a day and is fast enough that the users don't complain.

-- 
Michael Austin.