Recent

Author Topic: Database CONVERSION Paradox to FIREBIRD  (Read 1355 times)

Blavatsky

  • New Member
  • *
  • Posts: 10
Database CONVERSION Paradox to FIREBIRD
« on: August 03, 2023, 07:32:34 pm »
Hello,
I tried Interbase 3.5 Datapump but, it does not work for me as I seem to be unable to add my paradox tablename to the script generator.
Are there any cheap or FREE programs for conversion / datapumping from Paradox .db to Firebird .FDB format on Windows 10 ?
Any help is appreciated
Blavatsky

dsiders

  • Hero Member
  • *****
  • Posts: 947
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #1 on: August 03, 2023, 07:51:30 pm »
Hello,
I tried Interbase 3.5 Datapump but, it does not work for me as I seem to be unable to add my paradox tablename to the script generator.
Are there any cheap or FREE programs for conversion / datapumping from Paradox .db to Firebird .FDB format on Windows 10 ?
Any help is appreciated
Blavatsky

TParadoxDataset is available in OPM... but I have not used it. The export/import part would be up to you.
Preview Lazarus 3.99 documentation at: https://dsiders.gitlab.io/lazdocsnext

wp

  • Hero Member
  • *****
  • Posts: 11478
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #2 on: August 03, 2023, 07:53:30 pm »
I think the first task is: How to read the paradox files?

Well, there is a lazparadox package which comes along with the Lazarus installation - go to "Packages" > "Install/uninstall packages", select it in the right list, click "Install selection" and "Save and rebuild IDE". I am not using this package because it requires an external dll.

But there is another package, TParadoxDataset, which is self-contained. However, it allows only read-only access to the paradox tables - but this is all you need for converting to another database format. This package can be installed by the Online-Package-Manager of Lazarus.

I once built a paradox file viewer based on this package (https://github.com/wp-xyz/ParadoxViewer), and it even has a converter to SQLite3 databases. You hopefully can get an idea from it how to extend it to FireBird.

rvk

  • Hero Member
  • *****
  • Posts: 5651
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #3 on: August 03, 2023, 11:10:30 pm »
I think the ibdatapump is still your easiest and best bet (without any programming).

How did you try to define and access the paradox source?
Via ODBC or BDE or ADO?
That would indeed be the first step.

Blavatsky

  • New Member
  • *
  • Posts: 10
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #4 on: August 04, 2023, 12:22:07 am »
I TRIED BDE datasource

I TRIED BDE datasource as that is the only option for PARADOX .DB file

also, I tried all versions of Database Comparer 8 (32, 64 and latest) and none of them even worked on win10 64 bit.This software contains a DATAPUMP as well.
they all malfunctioned after create new profile then click "folder" and it failed to open folder directory.
« Last Edit: August 04, 2023, 01:26:29 am by Blavatsky »

jcmontherock

  • Full Member
  • ***
  • Posts: 211
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #5 on: August 04, 2023, 09:25:20 am »
Try to export your database to SQL, then check your SQL file to see if it is ok with Firebird. If not, edit your script and correct it.
Windows 11 UTF8 64 - Lazarus 3.0RC2 64 - FPC 3.2.2

Thaddy

  • Hero Member
  • *****
  • Posts: 13273
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #6 on: August 04, 2023, 10:54:29 am »
I TRIED BDE datasource as that is the only option for PARADOX .DB file
That is not true. There are sources available for FPC to handle Paradox.
In all cases you will loose any meta-data, though: it is basically a matter of simply copying the records to the new database format.
I actually get compliments for being rude... (well, Dutch, but that is the same)

rvk

  • Hero Member
  • *****
  • Posts: 5651
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #7 on: August 04, 2023, 12:35:44 pm »
I TRIED BDE datasource
[...]
also, I tried all versions of Database Comparer 8 (32, 64 and latest) and none of them even worked on win10 64 bit.This software contains a DATAPUMP as well.
they all malfunctioned after create new profile then click "folder" and it failed to open folder directory.
I just tested this version of BDE with Interbase Datapump and it worked fine (in a Windows Sandbox):
https://www.medlogsystems.com/bdesetup.htm

So you probably have a problem setting up BDE/ODBC connection correctly.
On what system are you installing?

If you done all the things with ODBC Administrator etc. and you get a problem regarding access to a directory the problem could be that DBE creates a file in the root of C:\. It could be that that's prohibited on your system.

You could fiddle with the ODBC settings (under extra options) to see if you can make it create the .NET file somewhere else...
but if you can install DBE in a Windows Sandbox and run the datapump in there it might work easier.
(there files in C:\ are allowed)


Blavatsky

  • New Member
  • *
  • Posts: 10
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #8 on: August 04, 2023, 10:18:19 pm »
Windows Sandbox requires Win 10 Pro.
I will have to upgrade from Home Edition

rvk

  • Hero Member
  • *****
  • Posts: 5651
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #9 on: August 04, 2023, 10:59:00 pm »
Windows Sandbox requires Win 10 Pro.
I will have to upgrade from Home Edition
Or use VMWare, or VirtualBox, or an old Windows XP system, or ...

korba812

  • Sr. Member
  • ****
  • Posts: 377
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #10 on: August 05, 2023, 11:03:36 am »
If you done all the things with ODBC Administrator etc. and you get a problem regarding access to a directory the problem could be that DBE creates a file in the root of C:\. It could be that that's prohibited on your system.

You could fiddle with the ODBC settings (under extra options) to see if you can make it create the .NET file somewhere else...
but if you can install DBE in a Windows Sandbox and run the datapump in there it might work easier.
(there files in C:\ are allowed)
The problem with BDE access to root directory (C:\) can be solved by changing the "NET DIR" configuration of "Paradox" driver in "BDE Administrator" application (C:\Program Files\Common Files\Borland Shared\BDE\BDEADMIN.EXE).

Blavatsky

  • New Member
  • *
  • Posts: 10
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #11 on: August 16, 2023, 02:04:29 am »
Hi,
I ended up going to old XP computer with Delphi 5 DATAPUMP.
converted the databases (Paradox 7) I wanted into MS ACCESS databases ( .mdb)

Then I put primary key .... VERY IMPORTANT.

then I took them from the XP-win computer and put them on my win-10 (64-bit) computer.
Then I used DBMigrationNET inside
DatabaseNET5-Pro (64-bit) nice program
and pretty easy to use... NICE DATAPUMP features.
Installed FireBird 3.0 (64 bit) and Flamerobin (64-bit) registered ( connected the DATABASE )
Went into DBMigrationNET and did the DATAPUMP from MS ACCESS .mdb to
Firebird .fdb and it worked like a charm.

So now that I have a database... now I can concentrate on making a VCL APP 64-bit .... Incidently, I discovered that my Delphi 11.1 does NOT have a 64-bit platform FIREDAC installed it is only 32-Bit. How could they make such a big mistake ? the whole FMX platform they support is 64-bit

rvk

  • Hero Member
  • *****
  • Posts: 5651
Re: Database CONVERSION Paradox to FIREBIRD
« Reply #12 on: August 16, 2023, 11:03:28 am »
So now that I have a database... now I can concentrate on making a VCL APP 64-bit .... Incidently, I discovered that my Delphi 11.1 does NOT have a 64-bit platform FIREDAC installed it is only 32-Bit. How could they make such a big mistake ? the whole FMX platform they support is 64-bit
VCL App? Delphi 11.1? FIREDAC?
This is a FPC/Lazarus forum so you might consider switching to Lazarus  ;)

But I would be surprised if there is no 64 bit FIREDAC with Delphi 11.1 (maybe an install omission) but you can ask that in the Delphi forums.

 

TinyPortal © 2005-2018