# Adabas, Natural, migrate data from the Adabas db to relational db

**URL:** <https://techcommunity.softwareag.com/t/adabas-natural-migrate-data-from-the-adabas-db-to-relational-db/263780>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Natural, Adabas-on-Mainframes, Natural-on-Mainframes\
**Created:** [September 18, 2022, 10:27am UTC](https://techcommunity.softwareag.com/t/adabas-natural-migrate-data-from-the-adabas-db-to-relational-db/263780 "2022-09-18T10:27:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![aliabdullahsadikov13](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@aliabdullahsadikov13](https://techcommunity.softwareag.com/u/aliabdullahsadikov13)\
**Post date:** [September 18, 2022, 10:27am UTC](https://techcommunity.softwareag.com/t/adabas-natural-migrate-data-from-the-adabas-db-to-relational-db/263780/1 "2022-09-18T10:27:02Z")

</div>

I have an old computer and Adabas on Mainframe. I need to migrate all data from the Adabas database to relational.  
Does anybody have an idea?

---

<div class="post-metadata">

**Author:** ![wolfgang.winter](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/wolfgang.winter/32/17954_2.png) [@wolfgang.winter](https://techcommunity.softwareag.com/u/wolfgang.winter)\
**Post date:** [September 18, 2022, 5:19pm UTC](https://techcommunity.softwareag.com/t/adabas-natural-migrate-data-from-the-adabas-db-to-relational-db/263780/2 "2022-09-18T17:19:19Z")

</div>

Assuming you need an offline process you will need to UNLOAD DECOMPRESS the files from the mainframe database, transfer it to the target system, find a reasonable mapping for the individual fields, most likely normalize the MUs and PEs and “somehow” load it into your relational database with their native toolset.

---

<div class="post-metadata">

**Author:** ![James\_Gilpin1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/james_gilpin1/32/152_2.png) [@James\_Gilpin1](https://techcommunity.softwareag.com/u/James_Gilpin1)\
**Post date:** [September 18, 2022, 5:31pm UTC](https://techcommunity.softwareag.com/t/adabas-natural-migrate-data-from-the-adabas-db-to-relational-db/263780/3 "2022-09-18T17:31:32Z")

</div>

Look for a product called AdaMagic

James

---

<div class="post-metadata">

**Author:** ![Eugene.Miklovich](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@Eugene.Miklovich](https://techcommunity.softwareag.com/u/Eugene.Miklovich)\
**Post date:** [September 19, 2022, 11:47am UTC](https://techcommunity.softwareag.com/t/adabas-natural-migrate-data-from-the-adabas-db-to-relational-db/263780/4 "2022-09-19T11:47:31Z")

</div>

Software AG has a product called ADABAS EVENT replicator and TREEHOUSE also has a product that will do this, however I suspect you do not want to purchase a product and want to do this manually. In that case you can use ADABAS utilities as Wolfgand mentioned or just write NATURAL programs to write to a work file. For MU’s and PE’s to normalize (as per Wolfgang) you will need to include two additional fields on the MU or PE records: the ISN and occurrence number. This is how you will link the Child Table to the Parent.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [March 18, 2023, 11:47am UTC](https://techcommunity.softwareag.com/t/adabas-natural-migrate-data-from-the-adabas-db-to-relational-db/263780/5 "2023-03-18T11:47:48Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.