Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Navision system tablenames in german
EmiliaMeier
Member Posts: 6
Hi everybody,
I am trying to upgrade a SQLServer database for our customer from Navision 3.70 to 4.0.
As I wanted to convert the 3.70 database by opening in Navision Client 4.0 an error occured.
"Select ... From "Object" AS O ..." => Invalid Object "Object"....
In the Enterprise Manager I saw that the name of the expected Object is "Objekt". As well all the other Navision tables have been created with german identifiers (Zugriffsrecht, Mitglied von ...). Renaming these objects into english didn't suceed. Then there has been an intern syncronisation problem.
Can anybody tell me what to do in this case?
Thanks,
Emi
I am trying to upgrade a SQLServer database for our customer from Navision 3.70 to 4.0.
As I wanted to convert the 3.70 database by opening in Navision Client 4.0 an error occured.
"Select ... From "Object" AS O ..." => Invalid Object "Object"....
In the Enterprise Manager I saw that the name of the expected Object is "Objekt". As well all the other Navision tables have been created with german identifiers (Zugriffsrecht, Mitglied von ...). Renaming these objects into english didn't suceed. Then there has been an intern syncronisation problem.
Can anybody tell me what to do in this case?
Thanks,
Emi
0
Comments
Therefore it should have nothing to do with the object caption.
Sorry, but I have no solution for your problem at this time.
Microsoft Dynamics NAV Developer since 1997
MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
thanks for your answer!
That's exactly my problem. I only got a Sql-Server backup of our customers database and restored it on our server. Unfortunately the specified tables have all been named with german identifier. As they' re created by the installer of Navision, I have no influence up on the table names. Also SqlServer doesn't differ between name and caption. The upgrade command of the Navision 4.0 Client however expects an english identifier. At all I don't know why these identifiers are german instead of english but strangely the Navison 3.70 Client works fine with the german tablenames.
Emi
Have you followed all steps in migration documents ??
We have recently migrated a customer from Navision 2.60 to 4, and we don't have this problems (Here in Spain we had 2.60 tablenames in Spanish and in 4.0 are in English).
Bye
Make a Navision-backup and restore it in a native DB. Do the migration in the native DB. Make a Navision-backup and restore it in SQL?
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
I copied the table 'objekt' to 'object' (renaming it doesn't help at all) and then rename the column 'Typ' of the new table into 'Type'. After these changes the convertion of the database succeeded properly.
Thanks for your effort!
Bye,
Emi