Solved

Exporting data from Pervasive (SQL)

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Read about achieving the basic levels of HRIS security in the workplace.
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

760 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

24 Experts available now in Live!

Get 1:1 Help Now