Re: emulate sql-server / MSDE with oracle

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sat, 6 Jun 2009 13:38:41 -0700 (PDT)
Message-ID: <2c52538e-f387-4dc8-b1e9-c6f3b1f45e6b_at_l28g2000vba.googlegroups.com>

On Jun 5, 8:14 am, Andreas Moroder <Andreas.moroder_at_[nospam]sb- brixen.it> wrote:
> Malcolm Dew-Jones schrieb:> Andreas Moroder (Andreas.moroder_at_[nospam]sb-brixen.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 all
> > : 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: TSQL  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 -- Received on Sat Jun 06 2009 - 15:38:41 CDT