• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

pervasive sql databse transfer all data to SQL 2008 database

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
coolfiger
Asked:
coolfiger
  • 3
  • 2
1 Solution
 
mirtheilCommented:
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
 
Bill BachPresidentCommented:
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
 
coolfigerAuthor Commented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Bill BachPresidentCommented:
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
 
coolfigerAuthor Commented:
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
 
coolfigerAuthor Commented:
Solved the issue on my own
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now