Exporting data from Pervasive (SQL)


I have never used Pervasive before, and need to find a way of exporting the data from
Pervasive and importing it into SQL Express. I dont have the database (and dont want to have to purchase Pervasive). The DB resides at a client site, and need to be able to migrate it to
sql express.
so would like instruction on how to get the database into an sql file or SQL express
or even MS Access (or mysql).

Does anyone know
Who is Participating?

Improve company productivity with a Business Account.Sign Up

HainKurtConnect With a Mentor Sr. System AnalystCommented:
looks like btrieve db files...
HainKurtSr. System AnalystCommented:
do you want a free version?

this app can export data from pervasive

HainKurtSr. System AnalystCommented:
on the client, pervasive odbc should be installed

create a dsn on client, name it myPervasive, connect to db, test it...
create an access db (or open excel), link to table using dns, copy paste or write an update insert query using this linked table...
HainKurtSr. System AnalystCommented:
check this page on how to retrieve data from pervasive using ODBC

junebrownAuthor Commented:
OK. I think I understand

do you know what BTR files are ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.