Import BDE Paradox Database into SQL Server (Or anything really)

Import BDE Paradox Database into SQL Server (Or anything really)

I was recently asked to take a look at a Paradox Database with the aim of migrating it over to SQL Server.

You will first need to make sure you have the BDEInfoSetup Utility installed (Download can be found here http://www.willneumann.net/2008/09/bdeinfosetup-utility-download/).

Once installed you will need to create a DSN

- Navigate to C:\Windows\SysWOW64
- Open odbcad32.exe
- Create DSN using the "Microdoft Paradox Driver (*.db)" and point it to the folder that contains all of your *.db files

Once done you can use SSIS to push the data anywhere you need.


While this is great in that I am able to access all of the tables when there are 100 plus tables to migrate this becomes time consuming.

I stumbled across a great article written by Jerome (https://psycodedeveloper.wordpress.com/2013/01/25/c-application-to-import-paradox-data-to-sql-server/) who created a nice C# application that will import everything into SQL Server.