Re: emulate sql-server / MSDE with oracle

#1

On Jun 5, 8:14*am, Andreas Moroder <Andreas.moroder@[nospam]sb-
brixen.it> wrote:

Quote:

Malcolm Dew-Jones schrieb:> Andreas Moroder (Andreas.moroder@[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: 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 --

#2

On 04.06.2009 13:10, Andreas Moroder wrote:

Quote:

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 order to do this Oracle would have a completely different locking
system - built in as option! As soon as your application deals with
concurrent access there is no way that Oracle will be able to emulate MS
SQL Server (which is the engine behind MSDE). And why should they?
Developing on an Oracle database for another product which is much
cheaper does not really make sense, does it?

Kind regards

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: emulate sql-server / MSDE with oracle

comp.databases.oracle.misc comp.databases.oracle.misc

Re: emulate sql-server / MSDE with oracle - 06-06-2009 , 03:38 PM

Re: emulate sql-server / MSDE with oracle - 06-13-2009 , 04:57 AM