Re: SQL Server to Oracle conversion

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.
> >
Received on Sat Apr 01 2000 - 00:00:00 CST