Migration Help.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Migration Help.

Dhandapani Shanmugam
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 
Reply | Threaded
Open this post in threaded view
|

Re: Migration Help.

arnab biswas
Hi Dhandapani, 

Maybe the below link can assist you:



Regards,

Arnab Biswas
PRN: 18030241056
MOB: 7064342437

On Wed, 25 Mar, 2020, 22:17 Dhandapani Shanmugam, <[hidden email]> 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 
Reply | Threaded
Open this post in threaded view
|

Re: Migration Help.

srijith s
In reply to this post by Dhandapani Shanmugam
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 <[hidden email]> 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