[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: The best way to migrate the database to another platform

  • Thread starter Thread starter Andriy Mishin
  • Start date Start date
Status
Not open for further replies.
A

Andriy Mishin

Guest
[quote user="mfurgal"] The mention of Table Partitioning allows you to do a table-move, which essentially is a dump and load without any impact to the application. Very cool stuff. But you mention you are doing a platform migration. If you cannot deal with the downtime, check out this presentation I did last year at the PUG challenge: 410: Case Study: Platform and Data Migration with Little Downtime Basically, we leveraged the Pro2SQL product technology to do the platform migration. At the end of the day the downtime was 20 minutes to do the migration. This downtime would be irregardless of the database size as Pro2 replication is keeping the new database up to date with changes. You could do this yourself with the CDC product introduced in 11.7 as well. [/quote] This is very similar to my case. Thank you! I'll consider it. In addition, we have a license for Pro2Oracle, should we separately buy a license for Pro2OpenEdge? It seems to me that ProD&L does almost the same thing, but it costs several times cheaper. What do you think about ProD&L? Is it still supported? Maybe there are some nuances with him? P.S. Yesterday I sent the same post, but received a message that it should be checked by the forum moderator. Unfortunately, it seems that until now my post has not been approved. This is strange...

Continue reading...
 
Status
Not open for further replies.
Back
Top