Paradox export to Firebird SQL Import (without DataPump utility)
Requires:
1. Dezign Pro for Databases v4 or later
2. Paradox 7 for Windows
Steps:
1. Use Dezign to IMPORT the table structure from the Paradox database (which is a folder). You can select all or some tables. Do not have Paradox open against the same folder while you do this, otherwise Dezign will load empty table structures.
2. In Dezign, use File > Switch Target DBMS to change from Paradox to Firebird (or any other database it supports, and there are many)
3. In Dezign, use Database > Generate Database to make the SQL create script
4. Using IB_SQL or FlameRobin or anything else you like, create your empty Firebird SQL database.
5. Run the generated SQL against that new database. Now you have one or more empty table structures, but no data.
6. Using Paradox 7 tools or BDEAdmin, create an ALIAS that points to your new Interbase database.
7. Run Paradox 7. View tables. Pick one table at a time. Right click, ADD. For the target, first select the ALIAS which is your Firebird target. Then you will be able to select the table within that database.
8. Wait while Paradox pushes all the data to Firebird.
VOILA. Have a nice day.
1. Dezign Pro for Databases v4 or later
2. Paradox 7 for Windows
Steps:
1. Use Dezign to IMPORT the table structure from the Paradox database (which is a folder). You can select all or some tables. Do not have Paradox open against the same folder while you do this, otherwise Dezign will load empty table structures.
2. In Dezign, use File > Switch Target DBMS to change from Paradox to Firebird (or any other database it supports, and there are many)
3. In Dezign, use Database > Generate Database to make the SQL create script
4. Using IB_SQL or FlameRobin or anything else you like, create your empty Firebird SQL database.
5. Run the generated SQL against that new database. Now you have one or more empty table structures, but no data.
6. Using Paradox 7 tools or BDEAdmin, create an ALIAS that points to your new Interbase database.
7. Run Paradox 7. View tables. Pick one table at a time. Right click, ADD. For the target, first select the ALIAS which is your Firebird target. Then you will be able to select the table within that database.
8. Wait while Paradox pushes all the data to Firebird.
VOILA. Have a nice day.
Comments