Solved

Exporting data from Pervasive (SQL)

Posted on 2010-09-07
5
493 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Solution for warm standby SQL server 20 37
SQL Server - SQL field is defined as text 3 27
sql_mode 1 18
Exchange 2010 Database wont mount 3 23
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now