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

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.

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