Re: SQL Server to Oracle conversion

816 has added TOP to it .. is out on NT and Solaris .. maybe HPUX also.

Brian Beuning wrote:

> We want to support both DBMSs. We have been using SQL Server.
> One SQL Server query that is giving us trouble translating to Oracle
> looks like
> select top 16 .... with(readpast)
>
> With multiple machines running this query, they each get a different 16
> rows of the table (which is what we want). How is this done in Oracle?
>
> Thanks,
> Brian Beuning
>
> Josh Miller wrote:
>
> > I'm in the process of doing this myself. I think if you can get a separate
> > machine on which to install Oracle, your best bet is to download Oracle 8i,
> > the Oracle Migration Workbench, and you'll probably want Oracle Enterprise
> > Manager as well and just start installing and reading the documentation that
> > comes with it. The docs are all HTML, and can be a pain to navigate
> > sometimes, so you'll want to add every useful page you find to a favorites
> > folder. As far as doing the actual conversion, the Migration Workbench is
> > not perfect, but it's a pretty good start. Even if I have had to rewrite
> > some of the stored procedures, it helped in the beginning to have the tool
> > convert the Transact SQL to PL/SQL so I could compare the two languages (the
> > tool also moved the data very easily).
> >
> > Good luck! I'm only a couple of months ahead of you in this process, so if
> > you have any specific questions, there's a good chance I had to figure the
> > same thing out at some point myself, so feel free to ask (either post to
> > forum or email).
> >
> > Josh Miller
> > jmillerNOSPAM_at_mediabinNOSPAM.com
> > remove NOSPAM from name and domain above to email
> >
> > Dan <greenlex_at_yahoo.com> wrote in message
> > news:38cf5327.1412761323_at_news.lvrmr1.sfba.home.com...
> > > Have fun rewriting the stored procedures (if any)!
> > >
> > > On Wed, 02 Feb 2000 21:52:07 GMT, joe_celko_at_my-deja.com wrote:
> > >
> > > >Does anyone have tips for converting an application MS SQL Server to
> > > >Oracle 8? Is there a website with a list of differences in the
> > > >languages? Tools? Anything?
> > > >
> > > >--CELKO--
> > > >
> > > >
> > > >Sent via Deja.com http://www.deja.com/
> > > >Before you buy.
> > >

--

Tony Johnson
The Straford Group
PO Box 2875
Chandler, AZ 85244

Email : tonyj_at_primenet.com
Phone : (480)497-9685