pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigration from Postgresql 9 to Oracle 10g
8+ messages / 7 participants
[nested] [flat]
* Migration from Postgresql 9 to Oracle 10g
@ 2012-10-18 06:13 Shams Khan <shams.khan22@gmail.com>
0 siblings, 3 replies; 8+ messages in thread
From: Shams Khan @ 2012-10-18 06:13 UTC (permalink / raw)
To: pgsql-admin
Hi Experts,
I am in the process of migration from PG 9 to oracle. All of the
database objects has been migrated apart from functions. The main
issue I am facing with function code where DML statements are used in
the code. On the other side, Oracle doesn't support DML's in functions
or procedures. I used ESF Database Migration tool in order to convert
and does some remaing task manually. Is there any tool by which can
convert functions as well?
Regards,
Shams
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migration from Postgresql 9 to Oracle 10g
@ 2012-10-18 08:17 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Shams Khan <shams.khan22@gmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: Albe Laurenz @ 2012-10-18 08:17 UTC (permalink / raw)
To: Shams Khan *EXTERN* <shams.khan22@gmail.com>; pgsql-admin
Maybe you will get more enthusiastic support in an Oracle forum...
It is curious that you want to migrate form a fairly
current PostgreSQL version (you didn't say which one) to
an Oracle version that is already out of (Premier) support
and will be terminally abandoned next year.
Shams Khan wrote:
> On the other side, Oracle doesn't support DML's in functions
> or procedures.
That's not true.
You can use INSERT, UPDATE and DELETE in PL/SQL.
You can do about anything in PL/SQL.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migration from Postgresql 9 to Oracle 10g
@ 2012-10-18 08:31 Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
parent: Shams Khan <shams.khan22@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Gabriele Bartolini @ 2012-10-18 08:31 UTC (permalink / raw)
To: Shams Khan <shams.khan22@gmail.com>; +Cc: pgsql-admin
Hi Shams,
On Thu, 18 Oct 2012 11:43:52 +0530, Shams Khan <shams.khan22@gmail.com>
wrote:
> I am in the process of migration from PG 9 to oracle. All of the
> database objects has been migrated apart from functions. The main
> issue I am facing with function code where DML statements are used in
> the code. On the other side, Oracle doesn't support DML's in
> functions
> or procedures. I used ESF Database Migration tool in order to convert
> and does some remaing task manually. Is there any tool by which can
> convert functions as well?
I guess you are better off asking this to an Oracle forum or to Oracle
itself (or consultants).
Here I am sure you can find a lot of people (including myself) who are
really eager to talk about the inverse process and who are specialised
with that. We - for instance - manage Oracle to vanilla PostgreSQL
migrations with semi-automated tools able to convert PLSQL functions,
but not the other way around. Sorry. :(
Just for the record and to understand if this is due to PostgreSQL
limitations, are you in a position to give us technical/product reasons
for this decision?
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migration from Postgresql 9 to Oracle 10g
@ 2012-10-18 09:02 frank@frank.uvena.de
parent: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
0 siblings, 1 reply; 8+ messages in thread
From: frank@frank.uvena.de @ 2012-10-18 09:02 UTC (permalink / raw)
To: pgsql-admin
Am 2012-10-18 10:31, schrieb Gabriele Bartolini:
> Just for the record and to understand if this is due to PostgreSQL
> limitations, are you in a position to give us technical/product
> reasons for this decision?
I'd like to also know reasons for this....
Cheers,
Frank
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migration from Postgresql 9 to Oracle 10g
@ 2012-10-18 16:58 mike@trausch.us <mike@trausch.us>
parent: frank@frank.uvena.de
0 siblings, 0 replies; 8+ messages in thread
From: mike@trausch.us @ 2012-10-18 16:58 UTC (permalink / raw)
To: pgsql-admin
On 10/18/2012 05:02 AM, frank@frank.uvena.de wrote:
> Am 2012-10-18 10:31, schrieb Gabriele Bartolini:
>
>> Just for the record and to understand if this is due to PostgreSQL
>> limitations, are you in a position to give us technical/product
>> reasons for this decision?
>
> I'd like to also know reasons for this....
I'll admit, I'm curious, too.
I've helped people move from all sorts of databases to PostgreSQL over
the years, and usually the major concerns are getting away from
proprietary/expensive/insecure/unsafe and/or discontinued systems,
Oracle included in that.
--- Mike
--
A man who reasons deliberately, manages it better after studying Logic
than he could before, if he is sincere about it and has common sense.
--- Carveth Read, “Logic”
Attachments:
signature.asc (application/pgp-signature, 725B) download
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migration from Postgresql 9 to Oracle 10g
@ 2012-10-18 17:46 Grant Allen <gxallen@gmail.com>
parent: Shams Khan <shams.khan22@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Grant Allen @ 2012-10-18 17:46 UTC (permalink / raw)
To: pgsql-admin
On 18/10/2012 02:13, Shams Khan wrote:
> Hi Experts,
>
> I am in the process of migration from PG 9 to oracle. All of the
> database objects has been migrated apart from functions. The main
> issue I am facing with function code where DML statements are used in
> the code. On the other side, Oracle doesn't support DML's in functions
> or procedures.
Er, what? What exactly do you mean "Oracle doesn't support DML's in ... procedures"? Several million Oracle developers will be shocked to hear they've been writing phantom code updating, inserting, deleting etc. in their PL/SQL. Assuming that's what you mean by DML. Can you provide an example?
And +1 to the other comments on being curious about the motivation for the migration in this direction.
Ciao
Fuzzy
:-)
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migration from Postgresql 9 to Oracle 10g
@ 2012-10-19 03:31 Craig Ringer <ringerc@ringerc.id.au>
parent: Grant Allen <gxallen@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Craig Ringer @ 2012-10-19 03:31 UTC (permalink / raw)
To: Grant Allen <gxallen@gmail.com>; +Cc: pgsql-admin
On 10/19/2012 01:46 AM, Grant Allen wrote:
> On 18/10/2012 02:13, Shams Khan wrote:
>> Hi Experts,
>>
>> I am in the process of migration from PG 9 to oracle. All of the
>> database objects has been migrated apart from functions. The main
>> issue I am facing with function code where DML statements are used in
>> the code. On the other side, Oracle doesn't support DML's in functions
>> or procedures.
>
> Er, what? What exactly do you mean "Oracle doesn't support DML's in ... procedures"?
I'm assuming the intention was to write "DDL".
--
Craig Ringer
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migration from Postgresql 9 to Oracle 10g
@ 2012-10-19 04:20 Grant Allen <gxallen@gmail.com>
parent: Craig Ringer <ringerc@ringerc.id.au>
0 siblings, 0 replies; 8+ messages in thread
From: Grant Allen @ 2012-10-19 04:20 UTC (permalink / raw)
To: pgsql-admin
On 18/10/2012 23:31, Craig Ringer wrote:
> On 10/19/2012 01:46 AM, Grant Allen wrote:
>> On 18/10/2012 02:13, Shams Khan wrote:
>>> Hi Experts,
>>>
>>> I am in the process of migration from PG 9 to oracle. All of the
>>> database objects has been migrated apart from functions. The main
>>> issue I am facing with function code where DML statements are used in
>>> the code. On the other side, Oracle doesn't support DML's in functions
>>> or procedures.
>>
>> Er, what? What exactly do you mean "Oracle doesn't support DML's in ... procedures"?
>
> I'm assuming the intention was to write "DDL".
Ah. Well, not as plain statements - very true. But wrap them in "execute immediate" and one is good to go :)
But we digress ... I'm still fascinated to find out what's driving the move away from Postgres.
Ciao
Fuzzy
:-)
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2012-10-19 04:20 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-18 06:13 Migration from Postgresql 9 to Oracle 10g Shams Khan <shams.khan22@gmail.com>
2012-10-18 08:17 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2012-10-18 08:31 ` Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
2012-10-18 09:02 ` frank@frank.uvena.de
2012-10-18 16:58 ` mike@trausch.us <mike@trausch.us>
2012-10-18 17:46 ` Grant Allen <gxallen@gmail.com>
2012-10-19 03:31 ` Craig Ringer <ringerc@ringerc.id.au>
2012-10-19 04:20 ` Grant Allen <gxallen@gmail.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