Error while trying to restore to SQL server

Suja
Suja Member Posts: 46
edited 2010-07-22 in NAV/Navision Classic Client
Hi

We have performed a database upgrade from NAvision Native 2.6 to NAvision 4.0 Sp1 (Native DB) successfully. The database contain lots of chinese captions and also some of the datas are also in Chinese.

After upgrade , now we want to convert the database from Native to SQL Server 2000 environment.I did a full backup of the Native database (objects & datas) and while trying to restore to the newly created database in SQL it prompts me the error ..

"Customer Price Group Contains a value in a Code field that cannot be used with MBS- NAvision

Field - Code
Value - <some funny characters>

Any advice/ideas are greatly appreciated

Regards
Suja

Comments

  • ara3n
    ara3n Member Posts: 9,258
    You need to select a coalation that has Chinese characters. Otherwise you can't have chinese characters in any key. So you option is to rename the code to integers.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • mgm
    mgm Member Posts: 126
    I ran into the same error.
    Is there any tool with which you can check for 'funny' characters?
    So, something you can use in the native database that checks if the collation you want to use in SQL will cause any errors.

Categories