Re: Has anyone converted from Sybase to Oracle?

Yep, that's right. The conversion of stored procedures is one of the problems you're going to run into as is the conversion of views and triggers. If you use stored procedures with your dw's your problems are going to be even larger it is really a hell to write a SP to work with a DW you must run some kind of packet I'm not quite sure which one but it's in the manual.
Another thing you might want to keep in mind are the differences between the datatypes of the DB environments e.g. Oracle does not know the datatype DATE only DATETIME.
The only thing I can suggest you to do is, if you are going to port your apps to Oracle do not consider it lightly (especially if you have large apps) and follow a descent Oracle course before you begin.

Personally I think you're better of running two DB environments.

James Douglas <genesis-software_at_worldnet.att.net> wrote in article <01bbd70e$44ce37e0$936993cf_at_jimdougl>...
> I understand the conversion of stored procedures can be one problem.
>
> Don Burdick <burdick_at_dccc.org> wrote in article
 <329360C3.3058_at_dccc.org>...
> > Has anyone out there converted from Sybase to Oracle?
> >
> > My organization is more or less being forced to install Oracle to run a
 

> > specific piece of software. I'm unfamiliar with Oracle but I don't
 feel
> > that it is a good idea to run both Oracle and Sybase simultaneously as
 I
> > have a division of three including myself.
> >
> > All of our front-end applications are written (or will be converted to)
 

> > PowerBuilder.
> >
> > On a personal level it is obviously a great thing to do for my resume,
> > but on a professional level I'm not sure what I'm up against.
> >
> > Please email me with any responses.
> >
> > -Don
> > email: burdick_at_dccc.org
> >
>
  Received on Wed Nov 20 1996 - 00:00:00 CET