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/

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

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/