pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCan we convert from Postgres to Oracle !!???
13+ messages / 11 participants
[nested] [flat]
* Can we convert from Postgres to Oracle !!???
@ 2006-10-17 08:51 Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>
0 siblings, 5 replies; 13+ messages in thread
From: Sandeep Kumar Jakkaraju @ 2006-10-17 08:51 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
Can we convert from Postgres to Oracle !!???
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Can we convert from Postgres to Oracle !!???
@ 2006-10-17 12:38 Berend Tober <btober@seaworthysys.com>
parent: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>
4 siblings, 0 replies; 13+ messages in thread
From: Berend Tober @ 2006-10-17 12:38 UTC (permalink / raw)
To: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>; +Cc: pgsql-general@postgresql.org
Sandeep Kumar Jakkaraju wrote:
> Can we convert from Postgres to Oracle !!???
>
Umm, this would be the wrong forum for that.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Can we convert from Postgres to Oracle !!???
@ 2006-10-17 13:22 Ron Johnson <ron.l.johnson@cox.net>
parent: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>
4 siblings, 0 replies; 13+ messages in thread
From: Ron Johnson @ 2006-10-17 13:22 UTC (permalink / raw)
To: pgsql-general@postgresql.org
-----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-----
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Can we convert from Postgres to Oracle !!???
@ 2006-10-17 13:22 Harald Armin Massa <haraldarminmassa@gmail.com>
parent: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>
4 siblings, 0 replies; 13+ messages in thread
From: Harald Armin Massa @ 2006-10-17 13:22 UTC (permalink / raw)
To: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-novice@postgresql.org
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.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-21 21:03 Devrim GUNDUZ <devrim@commandprompt.com>
parent: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>
4 siblings, 2 replies; 13+ messages in thread
From: Devrim GUNDUZ @ 2006-10-21 21:03 UTC (permalink / raw)
To: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
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/
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-22 01:48 Berend Tober <btober@seaworthysys.com>
parent: Devrim GUNDUZ <devrim@commandprompt.com>
1 sibling, 2 replies; 13+ messages in thread
From: Berend Tober @ 2006-10-22 01:48 UTC (permalink / raw)
To: ; +Cc: pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
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!!???
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-22 02:49 Joshua D. Drake <jd@commandprompt.com>
parent: Berend Tober <btober@seaworthysys.com>
1 sibling, 1 reply; 13+ messages in thread
From: Joshua D. Drake @ 2006-10-22 02:49 UTC (permalink / raw)
To: Berend Tober <btober@seaworthysys.com>; +Cc: pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-22 03:10 Steve Atkins <steve@blighty.com>
parent: Berend Tober <btober@seaworthysys.com>
1 sibling, 1 reply; 13+ messages in thread
From: Steve Atkins @ 2006-10-22 03:10 UTC (permalink / raw)
To: PgSQL General <pgsql-general@postgresql.org>
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-22 03:54 Alvaro Herrera <alvherre@commandprompt.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 13+ messages in thread
From: Alvaro Herrera @ 2006-10-22 03:54 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Berend Tober <btober@seaworthysys.com>; pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
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.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-22 04:17 Ron Johnson <ron.l.johnson@cox.net>
parent: Steve Atkins <steve@blighty.com>
0 siblings, 0 replies; 13+ messages in thread
From: Ron Johnson @ 2006-10-22 04:17 UTC (permalink / raw)
To: pgsql-general@postgresql.org
-----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-----
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [NOVICE] Can we convert from Postgres to Oracle !!???
@ 2006-10-24 16:18 Chander Ganesan <chander@otg-nc.com>
parent: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>
4 siblings, 0 replies; 13+ messages in thread
From: Chander Ganesan @ 2006-10-24 16:18 UTC (permalink / raw)
To: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql; billm@enterprisedb.com
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-27 03:06 Jim C. Nasby <jim@nasby.net>
parent: Devrim GUNDUZ <devrim@commandprompt.com>
1 sibling, 1 reply; 13+ messages in thread
From: Jim C. Nasby @ 2006-10-27 03:06 UTC (permalink / raw)
To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>; pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
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)
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] Can we convert from Postgres to Oracle !!???
@ 2006-10-27 18:00 Richard Troy <rtroy@ScienceTools.com>
parent: Jim C. Nasby <jim@nasby.net>
0 siblings, 0 replies; 13+ messages in thread
From: Richard Troy @ 2006-10-27 18:00 UTC (permalink / raw)
To: Jim C. Nasby <jim@nasby.net>; +Cc: Devrim GUNDUZ <devrim@commandprompt.com>; Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>; pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
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/
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2006-10-27 18:00 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-17 08:51 Can we convert from Postgres to Oracle !!??? Sandeep Kumar Jakkaraju <sandeepkumar.jakkaraju@gmail.com>
2006-10-17 12:38 ` Berend Tober <btober@seaworthysys.com>
2006-10-17 13:22 ` Ron Johnson <ron.l.johnson@cox.net>
2006-10-17 13:22 ` Harald Armin Massa <haraldarminmassa@gmail.com>
2006-10-21 21:03 ` Devrim GUNDUZ <devrim@commandprompt.com>
2006-10-22 01:48 ` Berend Tober <btober@seaworthysys.com>
2006-10-22 02:49 ` Joshua D. Drake <jd@commandprompt.com>
2006-10-22 03:54 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-10-22 03:10 ` Steve Atkins <steve@blighty.com>
2006-10-22 04:17 ` Ron Johnson <ron.l.johnson@cox.net>
2006-10-27 03:06 ` Jim C. Nasby <jim@nasby.net>
2006-10-27 18:00 ` Richard Troy <rtroy@ScienceTools.com>
2006-10-24 16:18 ` Chander Ganesan <chander@otg-nc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox