Re: I can attach in SQL Server, but can I in Oracle?

Ron Fluegge wrote:

> First, I find your reply absurd ... especially in a newsgroup.
>
> I admitted up front that I was a "novice" at Oracle.
>
> However, if you were a "developer" you would know that it is also absurd to
> create two different versions of an application to support two or more data
> sources. That's the whole purpose behind a "data layer" in a multi-tiered
> application ... my datalayer IS WORKING with all of the 5 data sources
> listed below. So I do apparently know more than you do about application
> development. (now stepping off of soap box).
>
> I would hope that the rest of the participants in this newsgroup would be
> willing to offer some "useful" advice.
>
> Ron
>
> "Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message
> news:lop7jv0nqknstg8t08gi70j2siccug7f17_at_4ax.com...
> > On Fri, 08 Aug 2003 18:00:28 GMT, "Ron Fluegge" <rmflugge_at_swbell.net>
> > wrote:
> >
> > >First, let me apologize for the probably "simple and basic" question, but
> I
> > >have searched both Google and Deja without success.
> :
> :
> > >Please understand that I may not be using the correct terminology for the
> > >Oracle databases and tables -- I apologize.
> > >
> > >Any assistance would be greatly appreciated.
> > >
> > >Thanks.
> > >
> > >Ron Fluegge
> > >
> >
> >
> > You need to do the following things
> > 0.a find the financial resources to learn Oracle
> > 0.b alternatively hire a consultant
> > 0.c redevelop the sqlserver app for Oracle. It is not going to work
> > without change ever
> > 0.d regret you decided Oracle is Sqlserver sold by a different vendor
> > 0.e add several months to the release date
> > 0.f forget all of the points outlined above: they are crap and show
> > you don't know anything about Oracle
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address

Seemingly absurd or not ... Sybrand's points are valid. Oracle is not SQL Server [Quoted] sold by another company and if you are using the same code on both databases you [Quoted] will at best have something that won't scale and at worst will corrupt data.

[Quoted] How to tell whether Sybrand is correct? How have you handled the multiversioning [Quoted] concurrency model in Oracle?

If you don't know what I am referring to ... reread Sybrand's post.

Your desire to have a single code base is commendable but do understand that you [Quoted] are hardly the first person to think it could be done. Unfortunately I have been [Quoted] employed numerous times by "name" software firms to help them take apps written [Quoted] for SQL Server and make them work with Oracle. The result is always a rewrite: In part or in total.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)