Currently our databases are on an IBM Z/OS Mainframe and we want to do tests in AWS, but I want to know if I export the databases with ADABAS tools such as ADASAVE or, failing that, how to create the database structures and your adabas files to later populate the adbas files with data.
There is a 3rd-party product that can read a mainframe ADASAV backup, but with Adabas utilities alone you will need to perform file-by-file decompress/FTP/ADACMP/ADAMUP. ADACMP can handle a binary/RDW format input file.
Creating the database structures and your Adabas files to later populate the adbas files with data can be done using several different methods. One option is to use an ADR provider such as SqlServerDataSource or DataRowBuilder, which will help you create the necessary structure and tables in your database. Once completed, you can use Code First Migrations to migrate your data into the appropriate table formats. For this purpose, you could use an object-relational mapping (ORM) tool like Entity Framework Core or NHibernate managed beans. These tools allow you to declaratively define how your data should be stored in the database, making it easier for you to update or add new records later on without any programming required.