[ortho]

Hi all!

I have a problem, I'm trying to IMPORT/EXPORT an entire database from Pervasive 7x to SQL SERVER 2005 SP2.

I tried almost everything... and nothing worked yet...

Can someone helps me please?

[mirtheil]

What have you tried?
What do you mean by "nothing worked"?

Is this going to be a one time import/export or are you going to do it on a regular basis?

[ortho]

Hi Mirtheil!

This is going to be a one shot deal.

What did I try...? ... I tried this:
- Import/Eport from MSSQL but the driver for pervasive is not compatible with mssql
- I tried to import it in an access db and then import the access db into MSSQL. But due to access size limitations this wont work.
- I tried to export from Pervasive but the only 2 data formats I can export from PSQL aren't supported by MSSQL
- I tried to add all the tables in access as links table, but then when I select my mdb in the MSSQL import/export utility I don't see the linked tables...

I have to export/import 8 GB from almost 200 tables.

Once again this gonna be a one time deal.

Thanks in advance

Or Tho

[mirtheil]

Well, PSQL 7 is very old so I'm not surprised by some of your statements. I know newer versions of PSQL support exporting to CSV.
As I see it, you have a few options:
1. Write a program that reads the data and inserts it into the MSSQL database.
2. Upgrade the PSQL to a newer version (V8, v9, or v10) which supports exporting to CSV.
3. Use a third party program to export the data. Our DataXtraction (http://www.mirtheil.com/dataxtraction.asp) can export to CSV from any OLEDB or ODBC data source.
4. Use a third party tool like the Pervasive Integration products to move the data from PSQL to MSSQL.

[ortho]

Your app allow to export to csv, but does csv file has the same limitation that excel has...?

Because I have some tables that contains more than 2 000 000 rows... what's going to happen with them tables...

Does it allows to copy a db from PSQL to MSSQL ? because there's a lot of table in this DB and I don't wanna do each table one-by-one... I want to do it all at once.

Does your app support PSQL7x and MSSQL2005 ?

[mirtheil]

My app exports to CSV. Excel may have the limitation of opening any CSV with more than a certain number of records. My app uses standard functions to write to the file.
It does not copy a DB. It is for exporting only.

Yes, any database that supports ODBC or OLEDB can be accessed by my app.

[djpaubes]

Hi guys,

I'm an Oracle DBA by heart but sometimes I get little jobs like these..

So I have version 8 pervasive database and I need to get the data into mssql2k5 data on a different server.

So I setup the odbc driver fine as..
Datasource: pervasive
Description: bla

Address: server name
Data Source Name: is the database I want to export from

When I click test is connects fine.

I also setup a linked server as follows..
Provider: Pervasive.sql v8 OLE DB Provider
Product nameervasive
Provider string: ??? unsure
location: server name
catalog: ??? unsure.

So where to from here? Is my best option to try setup a DTS script and pull it accross? Its about 6gb of data...

I downloaded the tool from pervasive but didnt seem to work.. unsure as to why just did nothing when I clicked on it.

Sorry for asking a dumb question just a bit stumped. Was going to try dump it out to csv and go that way but that wouldnt be very geeky

Cheers,