Re: Road Map to move a home grown application from RPG to DB2 SQL or to any other data base platform

Have you looked a lot at the tools from www.databorough.com? They're part of Fresche Legacy - who, BTW, seems to be buying up the companies that Help Systems hasn't got yet!

As I recall from talking to Stuart Milligan some time ago, these tools can do analysis and find business rules, etc., which can help do a refactoring of applications.

If people really need to get things out of RPG - or even rearrange things, these tools might be worth a look.

Cheers
Vern

On 1/11/2017 12:15 PM, Nathan Andelin wrote:

There seems to be an implied assumption in the question that existing RPG
and DDS (DSPF, PRTF, PF, LF) might facilitate an automated conversion /
migration. However, that's a bad assumption. Even if someone were to offer
automated migration tools based on existing RPG and DDS code, the final
output would be disastrous, the implementation would be problematic, and
end-users would balk when they tried to use the application. There's just
too big of a paradigm shift to make it work.

Migrating database containers (i.e. tables and indexes) can be automated.
However, most likely you'd end up needing to refactor the DB design before
trying to build on top of it.

I could explain more tools if we were talking about migrating applications
off other platforms to IBM i.



On Tue, Jan 10, 2017 at 4:13 PM, Mohammad Tanveer <surgum@xxxxxxxxx> wrote:

Idea is to take baby steps to move applications from as/400 to another plat
form..

1. change PF/LFs to SQL tables and indexes.
2. Convert RPG programs to SQL/CLI so that it can be migrated to SQL
Server.
3. Convert RPG reports to Tableu/Cognos/Crystal reports
4. Convert DSPF screens to some frame work like Angular JS
5. Migrate everything to another platform/cloud..

Regards