Thanks again the book is on order. I realize I have a lot of work to
do, I just don't want to rewrite over 500 stored procedures.
--
Regards,
Bill Lucas
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
news:sHZq9.60864$oq6.15001_at_sccrnsc01...
> The book is Expert One on One and is an excellent book. In the
first three
> chapters it does explain some differences between Oracle and
SQLServer which
> are important to what you are doing. It isn't so much a SQL 92
compiant
> issue, but the fact that the two databases work so differently.
Tom's site
> is also excellent asktom.oracle.com. (search for sqlserver)
Remember use
> bind variables.
> Jim
>
>
> "Bill Lucas" <WCLucas_at_coolblue.com> wrote in message
> news:PEYq9.28839$Lg2.7230575_at_news2.news.adelphia.net...
> >
> > "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> > news:hfhoqucf8kr1nun7fq0g4cm37gnotd8q0p_at_4ax.com...
> > > On Tue, 15 Oct 2002 15:53:20 GMT, "Bill Lucas"
> > <WCLucas_at_coolblue.com>
> > > wrote:
> > >
> > > >I have already found the Concepts manual referred to in this
news
> > > >group, but I was wondering if more targeted information might
be
> > > >available for my particular situation. I have been an MS DBA
for
> > the
> > > >last two years, and our company has recently released a SQL
Server
> > > >version of our application. Due to high customer demand we are
> > > >getting ready to port our application for an Oracle 8i back
end. I
> > am
> > > >digging through the concepts manual and starting to familiarize
> > myself
> > > >with the differences in nomenclature and structure. I will
need to
> > > >move on to some administrative stuff so I can come up to speed
on
> > > >Administrative tasks, Enterprise Manager and other such things.
> > > >
> > > >I was hoping someone here might be able to recommend additional
> > texts
> > > >to help me in the following areas.
> > > >
> > > >1. Administer Oracle and configuring Enterprise Manager
> > > >2. Porting T-SQL Code to PL/SQL
> > > >3. Returning Result sets in explicit XML Format (our middle
tier
> > > >consumes XML which is then returned to the client)
> > > >4. General Security information especially in regards to
Windows NT
> > > >Security integration.
> > > >
> > >
> > >
> > > 1 The Oracle Server Administrators Manual
> > > 2 the PL/SQL reference manual and the Application Developers
Manual
> > > 4 Net8 Administrators manual and the NT specific manual.
> > >
> > > You should NOT (I repeat: NOT) 'port' a sqlserver app to Oracle.
It
> > is
> > > NOT going to work. You'd better read the book by Thomas Kyte,
> > > especially the first three chapters, and return from your route
to
> > > HELL.
> > >
> > > Regards
> > >
> > >
> > > Sybrand Bakker, Senior Oracle DBA
> > >
> > > To reply remove -verwijderdit from my e-mail address
> >
> > Ok thanks now I _am_ scared :)
> >
> > Well I don't know if port is the right word. We would like to
keep as
> > much of the code base the same as possible but I don't really know
> > what that will get me. If it makes any difference we did write
the
> > SQL CODE on SQL Server as SQL92 compliant as we could. I think we
did
> > a better than average job. We went through some pains there in
hopes
> > that it would make getting an oracle version out the door quicker.
I
> > guess we'll have to rethink that premise.
> >
> > I'll check out the docs though thanks.
> >
> > --
> > Regards,
> > Bill Lucas
> >
> >
>
>
Received on Tue Oct 15 2002 - 15:10:24 CDT
