Solved

Exporting data from Pervasive (SQL)

Posted on 2010-09-07
5
537 Views
Last Modified: 2012-05-10
Hi,

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
0
Comment
Question by:junebrown
  • 4
5 Comments
 
LVL 51

Expert Comment

by:HainKurt
ID: 33619616
do you want a free version?

this app can export data from pervasive

http://www.razorsql.com/register5.html
0
 
LVL 51

Expert Comment

by:HainKurt
ID: 33619639
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...
0
 
LVL 51

Expert Comment

by:HainKurt
ID: 33619651
check this page on how to retrieve data from pervasive using ODBC

http://www.goldstarsoftware.com/press.asp
0
 

Author Comment

by:junebrown
ID: 33619699
OK. I think I understand

do you know what BTR files are ?
0
 
LVL 51

Accepted Solution

by:
HainKurt earned 500 total points
ID: 33619990
looks like btrieve db files...
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question