I am new to Accpac support and would like to understand just how complex it would be to move our installation from 5.2 with Pervasive SQL to 5.5 with MS SQL.  Our database is 1.5GB.  The upgrade would be done to a new server.   Thanks for any information - particularly on how big a job this would be.

It's simple.  Dbdump from Pervasive, Dbload to MSSQL.

To clarify Jay's post, there's two steps.  One is to upgrade from 5.2 to 5.5.  The other is to move from Pervasive to MS-SQL.  They are independent and can be done in either order - e.g. convert in Pervasive, then move to MS-SQL.  Or move to 5.2 MS-SQL, then convert.

Migration from 5.2 (Pervasive) to 5.5 (MS.SQL) will not be a big deal, as suggested you can do the same just by DBDUMP and then DBLOAD. But you need to take care of few things which are as follows:

1. Take note of all customised reports n customised forms or customised reports

    Which may need to modify  as the new DB format.

2. If you were using Optional fields then need to make necessary arrangements for 

    the same before migration from 5.2 to 5.5

3. Last but not the least, all open batches from all modules should be posted after

    the  DAY END

4. It is also advised to run Data integrity checked before starting this migration.

All the best,

Alam,

 Thanks for all the advice.  I appreciate your help.

Faye

You may also want to check the MS SQL collation method that you are using. Some collation methohds can create data problems with the conversion from Pervasive to MS SQL.

Set the MS SQL Collation method to Latin General Bin.