Is there some use case example to export main data out from Magento version 1.9.x:
- users + personal account related data
- product catalog
- orders
Having them exported in a understandable standard format to possibly import them back to any SQL like DB
Not strictly necessary to have an automatic tool but at leas the SQL queries to be performed to select the above without loosing related data to user/products/orders
Is it something feasible without getting crazy?
I've seen this post: Magento ER diagram of 1.9.x
Giving a full ER diagram of the data in Magento 1. I'm wondering if there's around already some query or tools that starting from this knowledge performs an export like describe above