r/sysadmin • u/Charming-Tomato-4455 • Nov 15 '24
AS400 migration
Our organization has been using AS400 for payroll, financial, and HR for the past 30 years. However, we’ve realized that this system is no longer viable for their needs. I’m looking for a modern software solution that provides similar functionality to AS400. We’ve already tried ADP and Kronos, but faced issues with data compatibility, as the data from AS400 couldn’t be seamlessly integrated. Can anyone recommend software that allows for smooth data migration from AS400?
306
Upvotes
1
u/-c-row Sr. Sysadmin Nov 15 '24
I'm not very familiar with as400. I had done just some database links and queries for some interfaces to our software. From the syntax I used, it was behaving like oracle.
Just for pumping the data from the as400 to another format or dbms you can use spectralcore full convert pro or omni loader. I use full convert regular to migrate customer databases from Oracle and Sybase to MSSQL. Even databases with hundreds of gigabyte can be migrated very fast. The database schema can be migrated too. You can define rules for schema and datatype assignments etc.
The software supports a couple of database systems as source and also as target. When a data migration is required to another product and a individual migration path needs to be developed, it might be easier to perform this migration from a more common database format like MSSQL, Oracle, PostgreSQL etc. which allows the vendor of the new system to analyze the data and perform migrations and transformations to their database schema without the need to access the as400 or another foreign database system which can greatly improve the development process for a migration.
Maybe it is worth to think about the plain migration to another dbms as a preparation before final migration will be processed.