Database CONVERSION Paradox to FIREBIRD

[Blavatsky]

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]

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.

[wp]

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]

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]

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.

[jcmontherock]

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.

[Thaddy]

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.

[rvk]

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]

Windows Sandbox requires Win 10 Pro.
I will have to upgrade from Home Edition

[rvk]

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]

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]

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]

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.