#1 2019-03-13 07:20:33

yogiyang
Member
Registered: 2010-08-18
Posts: 23

Reverse engineer existing database

Hello,

I have plethora of databases created in PostgreSQL, MySql and SQLite. And some of the databases are very large having 280 tables with average 30 fields per table.

Hand coding such large database structures in Mormot is proving to be a nightmare at best.

Is there any utility that can reverse engineer an existing database and build required classes for Mormot?

TIA

Yogi Yang

Offline

#2 2019-03-13 11:26:06

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,323
Website

Re: Reverse engineer existing database

You have an initial attempt of such class generation in SynDBExplorer.dpr sample.

Perhaps it may be worth enhancing for your purpose.

And... a way to contribute by a pull request? wink

Offline

#3 2019-03-16 12:17:31

yogiyang
Member
Registered: 2010-08-18
Posts: 23

Re: Reverse engineer existing database

Hello,

Thanks for the tip. I will give it a close look.

Offline

Board footer

Powered by FluxBB