On Thu, 26 Oct 2006, Jim C. Nasby wrote: > Date: Thu, 26 Oct 2006 22:06:30 -0500 > From: Jim C. Nasby <jim@xxxxxxxxx> > To: Devrim GUNDUZ <devrim@xxxxxxxxxxxxxxxxx> > Cc: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@xxxxxxxxx>, > pgsql-general@xxxxxxxxxxxxxx, pgsql-novice@xxxxxxxxxxxxxx, > pgsql-sql@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!??? > > On Sun, Oct 22, 2006 at 12:03:38AM +0300, Devrim GUNDUZ wrote: > > On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > > > Can we convert from Postgres to Oracle !!??? > > You can also run our software and get Oracle syntax for 1/25th the cost. > ...And if we're making commercial plugs here - Is that OK? - another option is to use my company's software to be able to write your apps with nearly any dialect of Sql and run it against nearly any RDBMS engine. (Oracle, Postgres, Sybase, Db2 and Informix are presently certified.) So, you write once, run anywhere - unique features and embeded code not withstanding, of course. With this toolset, you can also have an app that talks to multiple database types simultaneously. The system includes the option to journal on either client or server side and the journals can be played back against a database of a different RDBMS type - including blob and clob support, and time support with minute offset from GMT (developed for scientific applications). Only two hitches; the library that does this magic is written in Java, and, it's not free. -smile- Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 rtroy@xxxxxxxxxxxxxxxx, http://ScienceTools.com/