Solved

pervasive sql databse transfer all data to SQL 2008 database

Posted on 2011-09-27
7
315 Views
Last Modified: 2012-05-12
I need to get data from a pervasive 9 database to a SQL 2008 database. Help !

I'm no sql guru .. i know the basics ..

My sql 2008 server is separate from my pervasive sql server. They are on the same network
0
Comment
Question by:coolfiger
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 18

Expert Comment

by:mirtheil
ID: 36714051
You might have a couple of options.  
The first, and probably best, would be to export the data from PSQL using the Export Wizard.  This will export it to CSV (called SDF by PSQL).  THen you can import the data to MS SQL Server.

Another option would be to create a linked server on the MS SQL Server and access the PSQL data directly.  THis only works, in your case, if MS SQL is 32 bit since PSQL v9 only had 32 bit ODBC Drivers.

A third option is to use a tool like the Pervasive Data Integrator (http://integration.pervasive.com/) to map the data from PSQL to MS SQL and copy the data across.  
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 36714057
Is this a one-time extract, or do you need to do this repeatedly?

You can easily import data directly via SSIS by linking to the Pervasive ODBC driver. You will have to have DDF's, but this is fast and easy.

If you're not familiar with SSIS, then you can use the Export Data function of the Pervasive Control Center. Send the data to SDF (CSV) format, and you should be able to import it anywhere you want.
0
 
LVL 8

Author Comment

by:coolfiger
ID: 36716600
The thign with the csv is i have to do single tables which suck ... not to familar with ssis. Let me give this a try and get back to you
0
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
LVL 28

Expert Comment

by:Bill Bach
ID: 36716647
There are other ETL tools that may be useful as well, though each will have its own learning curve.  Check out the offerings like JasperSoft and Pentaho.  Like Data Integrator, these tools are designed to integrate disparate databases, making it much easier to link information together.
0
 
LVL 8

Accepted Solution

by:
coolfiger earned 0 total points
ID: 36965759
I solved this issue my self by using a dts. I had to use SQL 2000 as the odbc driver for pervasive was not detected by any newer version of MS SQL Server
0
 
LVL 8

Author Closing Comment

by:coolfiger
ID: 36984672
Solved the issue on my own
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

726 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