Re: SQL Server to Oracle conversion

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 Wed Mar 15 2000 - 00:00:00 CST