BDE conversion to MySQL

[AllanPool]

Hello,

Brand new to Lazarus.

Have an existing Paradox application that needs rewrite, looking at Lazarus / MySQL. 

Will have to write an import utility from BDE to MySQL.

It appears that I need to install Paradox files?

How do I do this?

thanks!!

[Handoko]

Hello AllanPool,
Welcome to the forum.

Have you managed to read/import the data? If not, maybe you can use TParadoxDataSet or TParadox:

https://wiki.freepascal.org/TParadoxDataSet
https://wiki.freepascal.org/TParadox

To install a third party component (TParadoxDataSet) you can use Online Package Manager:
Lazarus main menu > Packages > Online Package Manager

TParadox is bundled by the default download but you have to activate/install it:
Lazarus main menu > Packages > Install/Uninstall Packages > on the right filter, type: paradox

[AllanPool]

I believe that I need some paradox components in order to see the BDE DB.  I can access MySQL ok.

[Handoko]

Database programming is not my expertise but I know doing it using Lazarus isn't difficult. Here are some video tutorials, maybe useful:

https://wiki.freepascal.org/Lazarus_videos#Database

[valdir.marcos]

Hello,
Brand new to Lazarus.
Have an existing Paradox application that needs rewrite, looking at Lazarus / MySQL. 
Will have to write an import utility from BDE to MySQL.
It appears that I need to install Paradox files?
How do I do this?
thanks!!

If you just want to import your data from Paradox to MySQL, internet is full of tools for that. Just search for "paradox mysql conversion tool".

On the other hand, if want to convert your Delphi project which uses DBE + Paradox to Lazarus + MySQL, you can start using Lazarus project or unit converter tool.

[AllanPool]

It is neither of those.  This is a complex conversion from a Paradox Application so must be hand coded. 

The Paradox/BDE DB components are missing and I get errors when trying to install the lazarus paradox package. 
[I assume that is what we are supposed to do]

[egsuh]

Will have to write an import utility from BDE to MySQL.

BDE is a tool to connect to and operate on database tables, not database in itself. So you have to think in two separate tasks.

1) Moving Paradox tables (and queries, etc. if exist) to MySQL database
2) Using SQL connection, instead of BDE.

First one is easy.  But if you are not familiar with relational database, the second task may need some study.

[Handoko]

The video tutorials I suggested, show how to do the connection.