Reverse-engineering a database
Posted: 08 Sep 2009, 15:46
Hi
I am involved in an Opensource accounting project (TurboCASH). Unfortunately the database has not yet been documented. The head of the project was very involved in the previous version (TC 3) It used paradox tables as the database. Version 4, created by somebody else, uses a real RDBMS - firebird. I would like to reverse-engineer this database to see how each table is updated, and which tables and fields have an influence on which other tables and fields.
At the moment I am writing custom plugginns that use and access this database. One of my current projects involve custom reports from the database. I need to have the above information to help me with this project.
The tools I use or have access to is: Delphi 7, Delphi 2010 and ER/Studio 8 as well as Talend OpendStudio.
Thank you
I am involved in an Opensource accounting project (TurboCASH). Unfortunately the database has not yet been documented. The head of the project was very involved in the previous version (TC 3) It used paradox tables as the database. Version 4, created by somebody else, uses a real RDBMS - firebird. I would like to reverse-engineer this database to see how each table is updated, and which tables and fields have an influence on which other tables and fields.
At the moment I am writing custom plugginns that use and access this database. One of my current projects involve custom reports from the database. I need to have the above information to help me with this project.
The tools I use or have access to is: Delphi 7, Delphi 2010 and ER/Studio 8 as well as Talend OpendStudio.
Thank you