Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!dca6-feed2.news.algx.net!allegiance!feed2.news.rcn.net!rcn!netnews.com!fr.clara.net!heighliner.fr.clara.net!oleane.net!oleane!nnrp.oleane.net!not-for-mail From: "Laurent" Newsgroups: comp.databases.oracle.server Subject: Re: How to Build a similare DataBases on Oracle and SQLServer Date: Thu, 6 Jun 2002 08:20:23 +0200 Organization: Guest of France Telecom Oleane's newsreading service Lines: 32 Message-ID: References: <3CFE2CA4.59FD1C7B@exesolutions.com> NNTP-Posting-Host: 195.25.33.131 X-Trace: s1.read.news.oleane.net 1023344424 18945 195.25.33.131 (6 Jun 2002 06:20:24 GMT) X-Complaints-To: abuse@oleane.net NNTP-Posting-Date: Thu, 6 Jun 2002 06:20:24 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Xref: easynews comp.databases.oracle.server:149697 X-Received-Date: Thu, 06 Jun 2002 00:48:11 MST (news.easynews.com) Thanks Daniel for your answers. > 1. You are incorrect. Certainly with respect to 9i. I am using 8.1.7. personal edition to make some test and your answer I a really good news to us > 2. It is unreasonable to create similar stored procedures at the code level > though you may wish to create procedures that perform similar functions with the > same name. So, for example, a procedure that reserves airplane seats might exist > in both systems but the methodology of the code inside them will be different. I had seen it like this , because T-Sql seem to be fairly different than PL/SQL. I wish there would be no much trouble with parameter (DATETIME in SQLServer and DATE in Oracle, OUTPUT ,....) we ll have to make some significant test on that > 3. No. But there are very substantial differences in concurrency, locking, and > transactions that must be understood or you will fail. That will be a big work to anderstand that too. Thanks again . :-)