Technical Convert from 2.60 to 4.00 SP 1 SQL error

Sorcerer

Hi,

i 've got a little problem while converting my 2.60 database technically to 4.0 SP 1. (the database is already running on 3.70)

the sql error is (translated from german):

208,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Unknown Object Name 'Object'.
16945,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The Cursor has not been declared.

SQL:
SELECT O."ID" FROM "Object" AS O WHERE O."Type"=? ORDER BY O."ID"

May be it is a hint that the virtual table Object is called Objekt in german database...the 4.0 SP 1 version is german also...
Has anyone an idea???

kine

It is problem, that in some cases (in some versions) the virtual tables has localized names and in another no...

Please, if you have problem, create Navision native backup and restore it under new client. You will not have this problem...

Sorcerer

ok, this works fine....but its a little bit slow...
we have a 100 GB database and the backup has a duration of approx. 48 hours...

i hoped the conversion would be a little faster

kine

There is another way, but this is small "hack".

1) Create new clear DB on your server with the new version client.
2) Convert the old DB
3) Through enterprise manager transfer data from the new DB from table dbproperties to your converted DB (this will change the settings about localized virtual tables etc...) of course BACKUP your old data in your converted DB table dbproperties
4) Try to open your converted DB in new client...

kunstmann

I think, this Thread could help

We solved the Problem