Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: How to migrate data from Microsoft SQL database to Pervasive SQL and vice versa

    Hi,
    I would like to know what are the ways to migrate
    database
    (1) from MS SQL to Pervasive SQL
    (2) from Pervasive SQL to MS SQL

    Please advise.
    Thank you.Sally

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    The easiest way would be to use a tool like DataJunction (http://www.datajunction.com). Another option would be to write a tool that reads one database and writes to the other. You could use ODBC or OLEDB for that.
    That would only take care of the data. For the application, you would need to change the connection string to point to the other database and/or re-write some of the application to take into account the differences in the products.
    Last edited by mirtheil; 10-21-03 at 12:38.
    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
    Oct 2003
    Posts
    5

    Re: How to migrate data from Microsoft SQL database to Pervasive SQL and vice versa

    Originally posted by sallypeh
    Hi,
    I would like to know what are the ways to migrate
    database
    (1) from MS SQL to Pervasive SQL
    (2) from Pervasive SQL to MS SQL

    Please advise.
    Thank you.Sally
    We have a very easy to use tool to move from Pervasive to MS SQL Server. It handles everything from creating the database, tables, mapping fields, etc. Currently we do not handle the import back into Pervasive but we are going to roll that out shortly. We have a free demo you can download at http://www.classicsoftware.com/downld.htm

    It is called the Data Manager for Btrieve and Pervasive SQL. It is also a editor and browser with a nice explorer type interface. For SQL Serrver you need the Enterprise version.

    http://www.classicsoftware.com

Posting Permissions

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