Restoring a native into SQL

dustman
dustman Member Posts: 15
edited 2005-09-14 in NAV/Navision Classic Client
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

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Did you select "Data common to all companies" when you made the backup?
    There are no bugs - only undocumented features.
  • dustman
    dustman Member Posts: 15
    Yes I tried all different ways to make the backup.

    BTW I am trying to restore in 4.0
  • kriki
    kriki Member, Moderator Posts: 9,121
    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".
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories