Page 1 of 1
dotConnect universal sql conversion
Posted: Tue 10 May 2011 07:54
by giulioudo
Hi
is dotConnect able to automatically translate a Oracle function into the equivelant SQLServer function ?
Re: dotConnect universal sql conversion
Posted: Tue 10 May 2011 11:03
by object
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.
Posted: Tue 10 May 2011 14:16
by Shalex
@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 .