How do I convert from Accpac 5.2 Pervasive to Accpac 5.5 MS SQL 2

[62496]

Hi,

We are on Accpac 5.2 Pervasive.SQL. How do I convert it to MS SQL.

Regards,

62496

 

[Bluejay07]

To my knowledge, the only way to convert from Pervasive to SQL is by the following:

You can start with a DB dump. Next, create the databases in SQL, delete the companies in Accpac, recreate the companies in Accpac using SQL (from the drop down box) then load the data.

I hope this helps.

 

[Jay Converse]

Database Dump
Make new SQL databases
Database Load

 

[62496]

Thank you. I am going to give it s try.

 

[Nkadi]

Also be careful on collation methods on SQL DBs when migrating from Pervasive to Ms SQL.

Nkadi
CTO