SQL restore problem

zeon

We are trying to to migrate from native 5.0 SP1 to SQL Server 2008. We took a backup of the live database and did the following

1) Restored the FBK as FDB on a test environment
2) Ran a full database test
3) Used migrate.fob from Upgrade toolkit and made all necessary corrections to make the DB SQL Ready
4) Took a fresh fbk of the database
5) Created a blank SQL database
6) Tried restoring the "SQL Readied" fbk

After restore completes we get the following error:
You cannot delete or change type for the field Pay Base (in table G/L Account), before the value in the field is reduced to zero or empty in all records. The message was shown, because there was found a value which is not zero in entry no.='2710' in company...



The field Pay Base which it complains about is a new field 50000 and it is a boolean field.

The backup we are trying to restore does only have one company, but the cronus company is loaded in the database as well.

The database is 5.0 and tech upgraded to 5.0 SP1.

rdebath

Sounds like you've already got Cronus objects in the database.

Two options

• Start with a new SQL database with NO objects in it and restore your whole fbk, not just the company data.
• Before you restore your company data use the object designer Import function on the fbk (treating it like a fob file) and import all the different objects with replace all.

Either should do the trick, the first will also get the data that's not attached to any one company (eg users and permissions).