pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigration tool
5+ messages / 4 participants
[nested] [flat]
* Migration tool
@ 2006-08-12 15:42 RPK <rohitprakash123@indiatimes.com>
2006-08-15 21:27 ` Re: Migration tool Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 5+ messages in thread
From: RPK @ 2006-08-12 15:42 UTC (permalink / raw)
To: pgsql-admin
Is there any "Migration Toolkit" under development by PostgreSQL development
team? As we see in MySQL, it has a very good Migration Tool.
Can we expect the same in near future?
--
View this message in context: http://www.nabble.com/Migration-tool-tf2095697.html#a5776751
Sent from the PostgreSQL - admin forum at Nabble.com.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Migration tool
2006-08-12 15:42 Migration tool RPK <rohitprakash123@indiatimes.com>
@ 2006-08-15 21:27 ` Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jim C. Nasby @ 2006-08-15 21:27 UTC (permalink / raw)
To: RPK <rohitprakash123@indiatimes.com>; +Cc: pgsql-admin
On Sat, Aug 12, 2006 at 08:42:27AM -0700, RPK wrote:
>
> Is there any "Migration Toolkit" under development by PostgreSQL development
> team? As we see in MySQL, it has a very good Migration Tool.
>
> Can we expect the same in near future?
It's very unlikely there will every be any migration tools as part of
the core distribution, but there are already projects for various
databases on http://pgfoundry.org.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 5+ messages in thread
* migration tool
@ 2016-10-05 13:12 Dhandapani Shanmugam <postgresql95@gmail.com>
2016-10-05 19:41 ` Re: migration tool Venkata B Nagothi <nag1010@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Dhandapani Shanmugam @ 2016-10-05 13:12 UTC (permalink / raw)
To: pgsql-admin
Hi Gurus,
We are planning to migrate from Oracle to PostgreSQL database. I need your
help to identify the right tool to migrate the oracle data, I tried ora2pg
but looks very complex. Can you suggest any GUI tools for postgreSQL
migration please?
-Dhandapani
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migration tool
2016-10-05 13:12 migration tool Dhandapani Shanmugam <postgresql95@gmail.com>
@ 2016-10-05 19:41 ` Venkata B Nagothi <nag1010@gmail.com>
2016-10-06 12:04 ` Re: migration tool Dhandapani Shanmugam <postgresql95@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Venkata B Nagothi @ 2016-10-05 19:41 UTC (permalink / raw)
To: Dhandapani Shanmugam <postgresql95@gmail.com>; +Cc: pgsql-admin
On Thu, Oct 6, 2016 at 12:12 AM, Dhandapani Shanmugam <
postgresql95@gmail.com> wrote:
> Hi Gurus,
>
> We are planning to migrate from Oracle to PostgreSQL database. I need your
> help to identify the right tool to migrate the oracle data, I tried ora2pg
> but looks very complex. Can you suggest any GUI tools for postgreSQL
> migration please?
>
Well, ora2pg is the widely used tool to migrate from Oracle to PostgreSQL.
You can actually migrate most part of the database automatically, except
PL/SQLs and VIEWs which you will have to re-write manually.
As of i know there is NO other open-source tools like ora2pg available.
Regards,
Venkata B N
Database Consultant/Architect
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migration tool
2016-10-05 13:12 migration tool Dhandapani Shanmugam <postgresql95@gmail.com>
2016-10-05 19:41 ` Re: migration tool Venkata B Nagothi <nag1010@gmail.com>
@ 2016-10-06 12:04 ` Dhandapani Shanmugam <postgresql95@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Dhandapani Shanmugam @ 2016-10-06 12:04 UTC (permalink / raw)
To: Venkata B Nagothi <nag1010@gmail.com>; +Cc: pgsql-admin
Thank You all for sharing the inputs. *Rafael *shared the open source
migration tool http://www.omnidb.com.br which is awesome to use, Many
Thanks.
On Thu, Oct 6, 2016 at 1:11 AM, Venkata B Nagothi <nag1010@gmail.com> wrote:
>
> On Thu, Oct 6, 2016 at 12:12 AM, Dhandapani Shanmugam <
> postgresql95@gmail.com> wrote:
>
>> Hi Gurus,
>>
>> We are planning to migrate from Oracle to PostgreSQL database. I need
>> your help to identify the right tool to migrate the oracle data, I tried
>> ora2pg but looks very complex. Can you suggest any GUI tools for postgreSQL
>> migration please?
>>
>
> Well, ora2pg is the widely used tool to migrate from Oracle to PostgreSQL.
> You can actually migrate most part of the database automatically, except
> PL/SQLs and VIEWs which you will have to re-write manually.
>
> As of i know there is NO other open-source tools like ora2pg available.
>
> Regards,
> Venkata B N
>
> Database Consultant/Architect
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2016-10-06 12:04 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-12 15:42 Migration tool RPK <rohitprakash123@indiatimes.com>
2006-08-15 21:27 ` Jim C. Nasby <jnasby@pervasive.com>
2016-10-05 13:12 migration tool Dhandapani Shanmugam <postgresql95@gmail.com>
2016-10-05 19:41 ` Re: migration tool Venkata B Nagothi <nag1010@gmail.com>
2016-10-06 12:04 ` Re: migration tool Dhandapani Shanmugam <postgresql95@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