Recent

Author Topic: BDE conversion to MySQL  (Read 433 times)

AllanPool

  • Newbie
  • Posts: 3
BDE conversion to MySQL
« on: April 06, 2021, 08:43:51 pm »
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

  • Hero Member
  • *****
  • Posts: 4205
  • My goal: build my own game engine using Lazarus
Re: BDE conversion to MySQL
« Reply #1 on: April 06, 2021, 09:31:02 pm »
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
« Last Edit: April 06, 2021, 09:40:47 pm by Handoko »

AllanPool

  • Newbie
  • Posts: 3
Re: BDE conversion to MySQL
« Reply #2 on: April 06, 2021, 09:45:10 pm »
I believe that I need some paradox components in order to see the BDE DB.  I can access MySQL ok.

Handoko

  • Hero Member
  • *****
  • Posts: 4205
  • My goal: build my own game engine using Lazarus
Re: BDE conversion to MySQL
« Reply #3 on: April 06, 2021, 09:49:49 pm »
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

  • Hero Member
  • *****
  • Posts: 1026
Re: BDE conversion to MySQL
« Reply #4 on: April 06, 2021, 10:03:19 pm »
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

  • Newbie
  • Posts: 3
Re: BDE conversion to MySQL
« Reply #5 on: April 06, 2021, 10:21:49 pm »
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

  • Hero Member
  • *****
  • Posts: 712
Re: BDE conversion to MySQL
« Reply #6 on: April 06, 2021, 10:27:54 pm »
Quote
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

  • Hero Member
  • *****
  • Posts: 4205
  • My goal: build my own game engine using Lazarus
Re: BDE conversion to MySQL
« Reply #7 on: April 06, 2021, 10:33:20 pm »
The video tutorials I suggested, show how to do the connection.

 

TinyPortal © 2005-2018