Restoring a native into SQL

dustman

Hi there,

I have the following problem.

I want to restore data from a native backup into a sql database. The native has some tables with the prop: datapercompany=no. The problem is that for some reason it seems that the data from those tables are not exported.

When i open the sql database( after restoreing the database). I see the data from the tables with " datapercompany=yes" but not the data with the " datapercompany =no" . I tried all different backup possibilities, but no export of the data. Am I doing something wrong, or have not thought of anything special.

TIA

Greets

Erik

bbrown

Did you select "Data common to all companies" when you made the backup?

dustman

Yes I tried all different ways to make the backup.

BTW I am trying to restore in 4.0

kriki

Make a backup of all companies, "Data common to all companies" and objects
Remove the DB in SQL.
Recreate it.
Restore the full backup in SQL.

For some or other reason, if you import first the objects, it is not always possible to restore the "Data common to all companies".