Path: news.cambrium.nl!textnews.cambrium.nl!feeder8.cambrium.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.21.MISMATCH!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!l28g2000vba.googlegroups.com!not-for-mail
From: Mark D Powell <Mark.Powell@eds.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: emulate sql-server / MSDE with oracle
Date: Sat, 6 Jun 2009 13:38:41 -0700 (PDT)
Organization: http://groups.google.com
Lines: 42
Message-ID: <2c52538e-f387-4dc8-b1e9-c6f3b1f45e6b@l28g2000vba.googlegroups.com>
References: <h08d20$o8m$1@news.dtag.de> <4a27f710$1@news.victoria.tc.ca> 
 <h0b55o$hb3$1@news.dtag.de>
NNTP-Posting-Host: 67.167.134.14
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1244320721 10808 127.0.0.1 (6 Jun 2009 20:38:41 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 6 Jun 2009 20:38:41 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: l28g2000vba.googlegroups.com; posting-host=67.167.134.14; 
 posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; 
 Trident/4.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET 
 CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 
 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Jun 5, 8:14=A0am, Andreas Moroder <Andreas.moroder@[nospam]sb-
brixen.it> wrote:
> Malcolm Dew-Jones schrieb:> Andreas Moroder (Andreas.moroder@[nospam]sb-b=
rixen.it) wrote:
> > : Hello,
>
> > : more and more application use MSDE. Is there now way to let oracle
> > : emulate the MSDE behaviour ? This way it could be possible to have al=
l
> > : the data in oracle even if the application thinks it is in a MSDE.
>
> > In general, no.
>
> > Which behaviour do you wish to emulate?
>
> > (Which behaviour would one wish to emulate?)
>
> Hello,
>
> the more the better.
>
> If the new DB2 9.7 emulates most functions of a powerfull DB as oracle
> is, it should be possible for oracle to emulate msde.
>
> Bye
> Andreas

I see no valid reason why Oracle would want or need to emulate MSDE.

If the application does nothing but straight DML then you can
substitute one database for another; however, most applications
written on a database make use of the database specific language: T-
SQL for SQL Server, PL/SQL for Oralce, and SQLPL for DB2.  Oracle does
have a free tool, Migration Workbench, that will help you convert code
written for SQL Server or several other products into Oracle code.

But it the application is a vendor product you are most likely out of
luck.

HTH -- Mark D Powell --