Reverse-engineering a database

Get help on databases - MySQL, Oracle, Access, etc.
Post Reply
Mykhal
Registered User
Posts: 2166
Joined: 14 May 2009, 19:56
Location: Here

Reverse-engineering a database

Post by Mykhal »

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
Image
Dual Core E2140@1.6GHz, 2 Gig Ram, 500 Gig Samsung HD, 80 Gig Maxtor, Geforce 7300se :oops:
Thanx Ama :notworthy:
doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Re: Reverse-engineering a database

Post by doo_much »

Get yourself IBDesc - that'll at least give you the basics I think, but I'm no expert.
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
Post Reply