Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: moving to Oracle need recomendations...

Re: moving to Oracle need recomendations...

From: Bill Lucas <WCLucas_at_coolblue.com>
Date: Fri, 18 Oct 2002 14:47:31 GMT
Message-ID: <7aVr9.30730$Lg2.7737692@news2.news.adelphia.net>


Thanks for the resources and the tips...

I really appreciate it.

--
Have fun,
Bill Lucas
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:uk7kgl19u.fsf_at_hotpop.com...

> On Tue, 15 Oct 2002, WCLucas_at_coolblue.com wrote:
> > I have already found the Concepts manual referred to in this news
> > I was hoping someone here might be able to recommend additional
texts
> > to help me in the following areas.
> >
> > 1. Administer Oracle
>
>
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/serve r.817/a76956/toc.htm
>
> > and configuring Enterprise Manager
>
>
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.81 7/a85250/toc.htm
>
>
> > 2. Porting T-SQL Code to PL/SQL
>
> You may want to use Migration Workbench to see how much it can do
for
> you and then estimate from its output how much more work you have.
>
> Also, before you go and port all of your T-SQL code to Oracle, you
might
> want to try and rewrite some of your existing T-SQL code so the port
is
> even less painful. (This is of course, after you figure out the
pain
> points). This might be less cumbersome because your app is well
> debugged on SQL Server so changes there are likely to be faster to
> debug. Then, when the SQLServer specific stuff has to stay, port
that
> to the Oracle specific stuff.
>
> The nice thing is that you did database access in procs. All you
have
> to do is test procs, not apps. Run both Oracle and SQLServer procs
into
> tables and then diff the two outputs with selects.
>
>
> > 3. Returning Result sets in explicit XML Format (our middle tier
> > consumes XML which is then returned to the client)
>
>
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appde v.817/a86030/toc.htm
>
>
> > 4. General Security information especially in regards to Windows
NT
> > Security integration.
>
>
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/netwo rk.817/a85430/toc.htm
>
> > Our Target Network for this application is an NT 4 / 2000 domain
with
> > ORACLE Running on UNIX or NT Server. With at least one Windows
2000
> > Server to handle IIS and COM+ for our middle tier.
>
> Good luck.
>
> As others have pointed out, the Kyte book is definitely worth it.
>
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Fri Oct 18 2002 - 09:47:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US