dotConnect universal sql conversion

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
giulioudo
Posts: 1
Joined: Tue 10 May 2011 07:13

dotConnect universal sql conversion

Post by giulioudo » Tue 10 May 2011 07:54

Hi
is dotConnect able to automatically translate a Oracle function into the equivelant SQLServer function ?

object
Posts: 91
Joined: Tue 26 Oct 2010 08:29

Re: dotConnect universal sql conversion

Post by object » Tue 10 May 2011 11:03

giulioudo wrote:Hi
is dotConnect able to automatically translate a Oracle function into the equivelant SQLServer function ?
No. The purpose of such tools is to perform translations between application code and databases, not between various databases (and this is not always possible).

However, when using high level abstraction layers like ORM it is usually simple to read data from one database and store them in a database from another vendor without writing vendor-specific database code.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 10 May 2011 14:16

@giulioudo
You can implement "sql translation" with dotConnect Universal manually using UniSQL: http://www.devart.com/dotconnect/univer ... niSQL.html .
For example: http://www.devart.com/forums/viewtopic.php?t=20561 .

Post Reply