Print Page | Close Window

Pardox table support in import module

Printed From: TMS Software
Category: Business Tools
Forum Name: Data Modeler
Forum Discription:
URL: http://www.tmssoftware.com/site/forum/forum_posts.asp?TID=8804
Printed Date: 21 Aug 2019 at 4:43pm


Topic: Pardox table support in import module
Posted By: Grobety Stephane
Subject: Pardox table support in import module
Date Posted: 26 Mar 2018 at 8:34am
Hello,

As part of the migration of a large project from BDE to SQLite, I had to write a (rudimentary) Aurelius driver for BDE.

I was now wondering if there was a way to add that capability to data modeler: since the application I'm handling has a great many tables, it would really, help a lot if I had a tool to generate the model starting from the DB instead of having to reverse-engineer it all.

Thank you,
Stephane



Replies:
Posted By: Wagner R. Landgraf
Date Posted: 26 Mar 2018 at 12:53pm
You mean adding Paradox support to Data Modeler? Unfortunately such database is not supported, and I'm not sure we will ever support it, since it's an old one and very rarely used. Also Paradox has several limitations/differences from the traditional RDBMS that will probably require even more specific code in Data Modeler to be supported.


Posted By: Grobety Stephane
Date Posted: 27 Mar 2018 at 9:07am
Thank you for your answer

I was more thinking in terms of a plugin, really. Aurelius already has a way to abstract the DB implementation and I hoped there was a system to add to Data moderler's one.

Would you have a suggestion bout how I could generate entities automatically starting with BDE database ?


Posted By: Wagner R. Landgraf
Date Posted: 27 Mar 2018 at 9:14pm
I would do a manual import of BDE database structure and then generate a similar one in another database supported by Data Modeler (SQLite, MS SQL Server, etc.). Then import that structure in Data Modeler and generate Aurelius code.


Posted By: Feichtenschlager Thomas
Date Posted: 28 Mar 2018 at 7:53am
DataPump-Tools can create the structure out of a BDE-DB easily to a Interbase/FireBird-RDBMS. You can then import this structure to Data-Modeler and do/export to whatever you want.

I migrated some BDE Applications a few years ago. Even the old, free ones worked perfectly fine. You can use them to pump data and also to only extract the structure with many individual options for Fieldtype-mapping if the default does not fit...

Maybe this could be also an approach for you...

Regards, Tom


Posted By: Grobety Stephane
Date Posted: 28 Mar 2018 at 9:54am
Thank you both. I used the demo version of AbsoluteDB migration to port the data and the imported the structure from that DB.



Print Page | Close Window