Re: Has anyone converted from Sybase to Oracle?

If you're looking into working with ORACLE Servers and SYBASE Servers at the same time, check the new SQL-Programmer 2.0, where you can work with them at the same time. Open Stored Procedures side by side, for testing/migration, and quite more. Big $ saving there.

Check http://www.sfi-software.com for details or check the online documentation for SQL-Programmer 2.0 at: http://www.sfi-software.com/manuals/sqlprog20/sqlpro20.html

Call SFI at 819 778-5045 ext. 152 or email to mailto:info_at_sfi-software.com for details.

John Meyer,
Sylvain Faust Inc. (SFI)
http://www.sfi-software.com
Tel: 819 778-5045
Fax: 819 778-7943
MICROSOFT Solution Provider
ORACLE World Alliance Partner
SYBASE Synergy Partner

Arnoud Oortwijk <dutchboy_at_club.innet.be> wrote in article <01bbd720$7a60a520$da0a07c2_at_year2751>...
> 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 Thu Nov 21 1996 - 00:00:00 CET