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)
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)
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