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.
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.
Re: How to migrate data from Microsoft SQL database to Pervasive SQL and vice versa
Originally posted by sallypeh
I would like to know what are the ways to migrate
(1) from MS SQL to Pervasive SQL
(2) from Pervasive SQL to MS SQL
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.