Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql server transparent gateway

Re: sql server transparent gateway

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 02 Dec 2006 14:34:09 -0800
Message-ID: <1165098847.301765@bubbleator.drizzle.com>


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
Received on Sat Dec 02 2006 - 16:34:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US