Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!newshub.sdsu.edu!elnk-nf2-pas!elnk-pas-nf1!newsfeed.earthlink.net!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.tools Subject: Re: I can attach in SQL Server, but can I in Oracle? Date: Fri, 08 Aug 2003 14:34:48 -0700 Organization: EXE Message-ID: <3F341778.55B119A9@exxesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <0zRYa.9$7Q2.7@newssvr24.news.prodigy.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 76 Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82484 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" wrote in message > news:lop7jv0nqknstg8t08gi70j2siccug7f17@4ax.com... > > On Fri, 08 Aug 2003 18:00:28 GMT, "Ron Fluegge" > > 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 sold by another company and if you are using the same code on both databases you will at best have something that won't scale and at worst will corrupt data. How to tell whether Sybrand is correct? How have you handled the multiversioning 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 are hardly the first person to think it could be done. Unfortunately I have been employed numerous times by "name" software firms to help them take apps written 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@x.washington.edu (replace 'x' with a 'u' to reply)