Thread: Can we convert from Postgres to Oracle !!???
Can we convert from Postgres to Oracle !!???
Sandeep Kumar Jakkaraju wrote: > Can we convert from Postgres to Oracle !!??? > Umm, this would be the wrong forum for that.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/17/06 03:51, Sandeep Kumar Jakkaraju wrote: > Can we convert from Postgres to Oracle !!??? Are you asking permission? - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFNNkVS9HxQb37XmcRAiReAKDYU9/bWzTdlZ2KM9SWk9M9lH5BVQCgrIDl 8ey+EncXhj4NWjs2AzaMvSg= =gBjq -----END PGP SIGNATURE-----
Sandeep Kumar, > Can we convert from Postgres to Oracle !!??? technically: partial. Oracle supports most of the bleeding edge enterprise features of PostgreSQL. There are some limits however, esp. concerning inheritance, arbitrary length text fields and especially the missing support for pl/python, pl/pgsql and pl/perl. You might be able to replace those advanced features of PostgreSQL using PL/SQL. There are external database development tools available for Oracle if you need to match the functionality of PostgreSQLs integrated clients psql and pgAdmin III. support-wise: please ask your Oracle authorized support contract consultant to find out which Oracle support plan gives you a support comparable to the PostgreSQL one with the possibility to directly correspond with the database core architects and developers as well as unlimited access to the applications source code. economically: not enough information to give a fitting answer. But if you need a high cash burn rate to attract certain kinds of investors, Oracle will propably make that easier. Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.
On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > Can we convert from Postgres to Oracle !!??? Yes!!??? -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
Attachment
Devrim GUNDUZ wrote: > On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > >> Can we convert from Postgres to Oracle !!??? >> > > Yes!!??? > But of course, that begs the question: Why on earth would you want to!!???
Berend Tober wrote: > Devrim GUNDUZ wrote: >> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: >> >>> Can we convert from Postgres to Oracle !!??? >>> >> >> Yes!!??? >> > > But of course, that begs the question: Why on earth would you want to!!??? Cost? Extensibility? The feeling that you won't at any moment be greeted by men in dark suits wanting to audit your facilities? Using Open Source is cool? I can think of millions of other reasons. Joshua D. Drake > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
On Oct 21, 2006, at 6:48 PM, Berend Tober wrote: > Devrim GUNDUZ wrote: >> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: >> >>> Can we convert from Postgres to Oracle !!??? >>> >> >> Yes!!??? >> > > But of course, that begs the question: Why on earth would you want > to!!??? Sale of enterprise software into companies that have already paid for Oracle, built the infrastructure and have (Oracle) DBAs to handle tuning, HA and so on. Adding postgresql into that mix is a hard sell. Enterprise software that can support both postgresql and oracle backends is a much easier sell (even into those places that end up using postgresql). Cheers, Steve
Joshua D. Drake wrote: > Berend Tober wrote: > > Devrim GUNDUZ wrote: > >> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > >> > >>> Can we convert from Postgres to Oracle !!??? > >> > >> Yes!!??? > > > > But of course, that begs the question: Why on earth would you want to!!??? > > Cost? > > Extensibility? > > The feeling that you won't at any moment be greeted by men in dark suits > wanting to audit your facilities? > > Using Open Source is cool? Maybe you are thinking of the opposite process!!??? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/21/06 22:10, Steve Atkins wrote: > > On Oct 21, 2006, at 6:48 PM, Berend Tober wrote: > >> Devrim GUNDUZ wrote: >>> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: >>> >>>> Can we convert from Postgres to Oracle !!??? >>>> >>> >>> Yes!!??? >>> >> >> But of course, that begs the question: Why on earth would you want >> to!!??? > > Sale of enterprise software into companies that have already paid > for Oracle, built the infrastructure and have (Oracle) DBAs to handle > tuning, HA and so on. Exactly. If you've already ponied up the big bucks for an Oracle site license, why add extra complexity? > Adding postgresql into that mix is a hard sell. Enterprise software > that can support both postgresql and oracle backends is a much > easier sell (even into those places that end up using postgresql). - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFOvDUS9HxQb37XmcRAv5GAKCyrxv5sPrBR9oPAKeAQSX4VHpJzwCgxU8B P7Nai/Jd5A29FIqPe5TAh0g= =MvqY -----END PGP SIGNATURE-----
Sandeep Kumar Jakkaraju wrote: > Can we convert from Postgres to Oracle !!??? > If you've got (or are getting) an Oracle specific app and are considering switching for compatibility reasons, you might want to talk to the folks at EnterpriseDB . Their product is based on PostgreSQL but provides Oracle compatibility... Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org
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. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
On Thu, 26 Oct 2006, Jim C. Nasby wrote: > Date: Thu, 26 Oct 2006 22:06:30 -0500 > From: Jim C. Nasby <jim@nasby.net> > To: Devrim GUNDUZ <devrim@commandprompt.com> > Cc: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>, > pgsql-general@postgresql.org, pgsql-novice@postgresql.org, > pgsql-sql@postgresql.org > 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@ScienceTools.com, http://ScienceTools.com/