Pardox table support in import module

   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

Author	Message Share Topic Printable Version Delicious Digg Facebook Furl Google MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
Grobety Stephane Members Profile Find Members Posts Senior Member Joined: 04 Jan 2014 Posts: 108	Post Options Post Reply Quote Grobety Stephane Report Post Quote Reply Topic: Pardox table support in import module 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

Wagner R. Landgraf Members Profile Find Members Posts TMS Support Joined: 18 May 2010 Posts: 2362	Post Options Post Reply Quote Wagner R. Landgraf Report Post Quote Reply 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.

Grobety Stephane Members Profile Find Members Posts Senior Member Joined: 04 Jan 2014 Posts: 108	Post Options Post Reply Quote Grobety Stephane Report Post Quote Reply 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 ?

Wagner R. Landgraf Members Profile Find Members Posts TMS Support Joined: 18 May 2010 Posts: 2362	Post Options Post Reply Quote Wagner R. Landgraf Report Post Quote Reply 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.

Feichtenschlager Thomas Members Profile Find Members Posts Member Joined: 29 Oct 2011 Posts: 68	Post Options Post Reply Quote Feichtenschlager Thomas Report Post Quote Reply 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

Grobety Stephane Members Profile Find Members Posts Senior Member Joined: 04 Jan 2014 Posts: 108	Post Options Post Reply Quote Grobety Stephane Report Post Quote Reply 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.

TMS ALL-ACCESS

ALL PRODUCTS

SEARCH BY TAGS

Pardox table support in import module