dotConnect universal sql conversion

dotConnect universal sql conversion

Postby giulioudo » Tue 10 May 2011 07:54

Hi
is dotConnect able to automatically translate a Oracle function into the equivelant SQLServer function ?
giulioudo
 
Posts: 1
Joined: Tue 10 May 2011 07:13

Re: dotConnect universal sql conversion

Postby 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.
object
 
Posts: 89
Joined: Tue 26 Oct 2010 08:29

Postby 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 .
Shalex
Devart Team
 
Posts: 7709
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle