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

Getting the schema over is generally a bad idea. You will likely need sequences as you won't find any identity columns and such.

I haven't used the Transparent Gateway recently so I'll reserve comment but I was happy when I used it.

How much data and going from what version of SQL Server to what version of Oracle?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org