Re: emulate sql-server / MSDE with oracle
Date: Thu, 4 Jun 2009 09:26:03 -0700 (PDT)
Message-ID: <f3413651-1d3a-4f50-90f3-90c7f65c5641_at_e20g2000vbc.googlegroups.com>
On Jun 4, 7:10 am, 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.
>
> Bye
> Andreas
It is highly unlikely you can make the substitution but it would actually depend on the application and how it connects to the database and on the options used in the code. If the application uses a DSN then by changing the DSN you could point to Oracle which then only leaves several major potential problems. First is if the application uses T-SQL. Oracle will not recognize or deal with T-SQL.
Does MSDE support linked servers? If so consider if you can set up a up a linked server to Oracle and then redefine all the tables/views into calls to Oracle. The application would still connect to SQL Server but now the data is going from elsehwere.
Othersise why not just use the MSDE database the application is built on? What is the point of trying to switch it to Oracle?
HTH -- Mark D Powell -- Received on Thu Jun 04 2009 - 11:26:03 CDT