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

Mohammad,

A couple of other things to think about is the data structure of the file
and what needs to be done to convert properly.
Not always a straight conversion, I've used 3rd party apps to do this.

Also, if a multi-member file, how will you deal with the additional members?
Other databases do not handle the concept.
This would mean determining if you would merge these members or make
separate files as well as the associated program changes.

Of course, best thing is to convince others that moving away from the
platform is a fools folly. :)

Ken

-----Original Message-----
From: Mohammad Tanveer [mailto:surgum@xxxxxxxxx]
Sent: Tuesday, January 10, 2017 6:14 PM
To: Midrange Systems Technical Discussion
Subject: Re: Road Map to move a home grown application from RPG to DB2 SQL
or to any other data base platform

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


On Tue, Jan 10, 2017 at 2:19 PM, Paul Roy <paul.roy@xxxxxxx> wrote:

Hi Mohammad,

I am bit confused with your question ...
I have some experience moving SQL server applications to DB2, this
involved to write some RPG code...
I have some experience moving RPG application to Java in a way that
they can be run against "any" database including SQL server or DB2 ...
that could include in the architecture the use of SQL procedure and or
triggers


So I wonder if your question on moving RPG to SQL Server would not be
more appropriate on a Microsoft forum ?

Kind Regards,
Paul





From: Mohammad Tanveer <surgum@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 06/01/2017 01:40
Subject: Road Map to move a home grown application from RPG to DB2
SQL or to any other data base platform
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Is there anyone who did this kind of project? If yes was there any
road map documentation anyone can share?

Idea is to move RPG code into SQL procedures. Which can be port to
cloud or other platforms or databases like SQL Server.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD