pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigration Help.
3+ messages / 3 participants
[nested] [flat]
* Migration Help.
@ 2020-03-25 16:47 Dhandapani Shanmugam <postgresql95@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Dhandapani Shanmugam @ 2020-03-25 16:47 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I am working on DB2 migration to PostgreSQL, so would like to know if any
one have experience to share there stories and any recommendation. I worked
on ora2pg and it will give a nice assessment report which will help to plan
the migration strategy. In DB2 can we generate similar report to understand
the complexity of migration?
-D
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Migration Help.
@ 2020-03-26 06:59 arnab biswas <arnab.biswas@associates.scit.edu>
parent: Dhandapani Shanmugam <postgresql95@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: arnab biswas @ 2020-03-26 06:59 UTC (permalink / raw)
To: Dhandapani Shanmugam <postgresql95@gmail.com>; +Cc: pgsql-admin
Hi Dhandapani,
Maybe the below link can assist you:
https://www.spectralcore.com/fullconvert/howto/db2-to-postgres
Regards,
Arnab Biswas
PRN: 18030241056
MOB: 7064342437
On Wed, 25 Mar, 2020, 22:17 Dhandapani Shanmugam, <postgresql95@gmail.com>
wrote:
> Hi All,
>
> I am working on DB2 migration to PostgreSQL, so would like to know if any
> one have experience to share there stories and any recommendation. I worked
> on ora2pg and it will give a nice assessment report which will help to plan
> the migration strategy. In DB2 can we generate similar report to understand
> the complexity of migration?
>
> -D
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Migration Help.
@ 2020-03-30 16:35 srijith s <udbdoctor@gmail.com>
parent: Dhandapani Shanmugam <postgresql95@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: srijith s @ 2020-03-30 16:35 UTC (permalink / raw)
To: Dhandapani Shanmugam <postgresql95@gmail.com>; +Cc: pgsql-admin
I did a POC and it went well , I used a tool called full convert it migrate tables index constraints data and all , for security you have to write some scripts to convert ad groups to roles etc
Sent from my iPhone
> On Mar 25, 2020, at 12:47 PM, Dhandapani Shanmugam <postgresql95@gmail.com> wrote:
>
>
> Hi All,
>
> I am working on DB2 migration to PostgreSQL, so would like to know if any one have experience to share there stories and any recommendation. I worked on ora2pg and it will give a nice assessment report which will help to plan the migration strategy. In DB2 can we generate similar report to understand the complexity of migration?
>
> -D
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-03-30 16:35 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-03-25 16:47 Migration Help. Dhandapani Shanmugam <postgresql95@gmail.com>
2020-03-26 06:59 ` arnab biswas <arnab.biswas@associates.scit.edu>
2020-03-30 16:35 ` srijith s <udbdoctor@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