Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172

    Angry Unanswered: Pervasive -> SQL SERVER

    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?

    Less is more.
    How long is now?
    http://www.lesouterrain.com

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    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
    Less is more.
    How long is now?
    http://www.lesouterrain.com

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    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 ?
    Less is more.
    How long is now?
    http://www.lesouterrain.com

  6. #6
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  7. #7
    Join Date
    Dec 2007
    Posts
    1

    import data from pervasive to sql server 2005

    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •