Migration from Progess to Oracle?

Posted by LegacyUser on 23-Jan-2003 14:48

We've migrated from a Progress based pharmacy app but have a requirement to

keep the data available for a long time. How well does Progress migrate to

Oracle? Our user would have to do SQl statements to do their lookups but that

should be manageable.

Does anyone have any experience doing this?

Thanks

Lee Burns

St Johns Mercy Health Care

(Remove the mask to email me)

All Replies

Posted by LegacyUser on 24-Jan-2003 00:09

see here:

http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentry.p?kbid=17172&keywords=migrate%20progress%20oracle&wintype=kbwindow

"Lee" wrote:

>

We've migrated from a Progress based pharmacy app but have a requirement

>to

>keep the data available for a long time. How well does Progress migrate

>to

>Oracle? Our user would have to do SQl statements to do their lookups

>but that

>should be manageable.

>

>Does anyone have any experience doing this?

>

>Thanks

>

>Lee Burns

>St Johns Mercy Health Care

>(Remove the mask to email me)

Posted by LegacyUser on 28-Feb-2003 06:04

Lee,

This is something I did recently - it's a massive undertaking (at least if

you have 8 core databases and thousands of programs in your app like I do).

It's certainly possible but don't underestimate the amount of work that might

be involved. The best decision I made about my own migration was to get Progress

involved - I got Reto Mueller (reto@progress.com) from Progress Switzerland

to come to my office for three days - he guided me through the migration, showed

me the Dataserver utilities and discussed the code changes I would have to

make. I can thoroughly recommend him to you.

The code changes constitute the biggest single part of the work - you'll be

amazed at the changes you'll have to make - adding "VALIDATE" and "RELEASE"

statements all over the place. There's also some work to do if you use Report

Builder. It took us several man months. Good luck!

Regards,

Nick

This thread is closed