Обсуждение: Oracle PL/SQL to pg/PSQL conversion documentation.
Ideally I would like to see some template/example documentation of common feature conversion solutions. For example, "If you have a pl/sql TABLE function, you can do the same thing in postgres this way ..." I can generally Google specific problems and after enough time weeding out the garbage, I can usually find what I want, but maybe somebody has it all in one nice neat document and I just don't know about it.
Any links to such a resource would be greatly appreciated as well as any other links which you think I might find useful.
Thanks,Mike
On 12/02/2015 12:44 PM, Michael Moore wrote: > Ideally I would like to see some template/example documentation of > common feature conversion solutions. For example, "If you have a pl/sql > TABLE function, you can do the same thing in postgres this way ..." I > can generally Google specific problems and after enough time weeding out > the garbage, I can usually find what I want, but maybe somebody has it > all in one nice neat document and I just don't know about it. > Any links to such a resource would be greatly appreciated as well as any > other links which you think I might find useful. http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html > Thanks,Mike > -- Adrian Klaver adrian.klaver@aklaver.com
Thanks Adrian. I've seen that one before, and it is indeed very useful. Unfortunately it does not address many of the features that need converting. For example, how to deal with a BULK COLLECT, TABLE functions, context variables. Maybe I am hoping for too much. Again, thanks, Mike
On Wed, Dec 2, 2015 at 12:47 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/02/2015 12:44 PM, Michael Moore wrote:Ideally I would like to see some template/example documentation of
common feature conversion solutions. For example, "If you have a pl/sql
TABLE function, you can do the same thing in postgres this way ..." I
can generally Google specific problems and after enough time weeding out
the garbage, I can usually find what I want, but maybe somebody has it
all in one nice neat document and I just don't know about it.
Any links to such a resource would be greatly appreciated as well as any
other links which you think I might find useful.
http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.htmlThanks,Mike
--
Adrian Klaver
adrian.klaver@aklaver.com
2015-12-02 21:44 GMT+01:00 Michael Moore <michaeljmoore@gmail.com>:
Ideally I would like to see some template/example documentation of common feature conversion solutions. For example, "If you have a pl/sql TABLE function, you can do the same thing in postgres this way ..." I can generally Google specific problems and after enough time weeding out the garbage, I can usually find what I want, but maybe somebody has it all in one nice neat document and I just don't know about it.Any links to such a resource would be greatly appreciated as well as any other links which you think I might find useful.Thanks,Mike
some presentations can be touched on net
https://wiki.postgresql.org/images/a/a7/Oracle_migration_pgconf2012.pdf
https://pgconf.ru/media/2015c/darold.pdf
https://wiki.postgresql.org/images/a/a7/Oracle_migration_pgconf2012.pdf
https://pgconf.ru/media/2015c/darold.pdf
Regards
Pavel
Two VERY good links, Thanks Pavel.
On Wed, Dec 2, 2015 at 1:24 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
2015-12-02 21:44 GMT+01:00 Michael Moore <michaeljmoore@gmail.com>:Ideally I would like to see some template/example documentation of common feature conversion solutions. For example, "If you have a pl/sql TABLE function, you can do the same thing in postgres this way ..." I can generally Google specific problems and after enough time weeding out the garbage, I can usually find what I want, but maybe somebody has it all in one nice neat document and I just don't know about it.Any links to such a resource would be greatly appreciated as well as any other links which you think I might find useful.Thanks,Mikesome presentations can be touched on net
https://wiki.postgresql.org/images/a/a7/Oracle_migration_pgconf2012.pdf
https://pgconf.ru/media/2015c/darold.pdfRegardsPavel