Migrating data from Paradox to SQL Server

The company I work for has 开发者_C百科a very old system that uses Paradox. I need to rewrite this system and I need to migrate the data from Paradox to SQL Server 2008. How do I do this?

I found that it was possible to log into the Paradox database, copy and paste the data into Excel and then import the data into SQL Server in the normal way.

I had to do something exactly the same for a company I am working for

There are a few options

Export data in csv files through paradox

Or if your really lazy like me get the free trial for ESF database migration tool

you can select the entire Schema or database you want to convert

and convert everything all at once.

I was a little skeptical at first so I played with the free trial before buying it, but I must say it was worth buying.

Hope this helps it had me annoyed for a few months.