Upgrade from Nav2.6B to Nav4.0SP3 SQL2005

twdavis

I am starting the process to upgrade a database from Nav2.6B to Nav4.0SP3 SQL2005. I imported the SQLMigrate.fob objects to clean up the data. Had to make a few mods to create the Check Fields codeunit, but got past that point.
Now I am running the new Check Fields codeunit and getting an error:
Table2000000058 does not exist.
When I go to open or compile codeunit 104011 and 12 I get the same error.
I opened the same codeunits in Nav4.0 and have no problem.

Is there a solution to this issue?

Is there another MigrateSQL objects for upgrading a 2.6B database?

Nobody

This is a guess and may sound a little strange. In 2.6x these objects did not exist and it sounds like it can not resolve the permissions for those objects.

Is the 2.6 database on SQL2005 or SQL 2000 or C/Side?
What executables are you using with the 2.6 database?

twdavis

database is on C/Side.
running version 2.6B executable. imported the migrate.fob into the 2.6B database and proceeded from there.

The tabledata2000000058 referenced, seems to be TableInformation datatype: record that is referenced in CU104011

ara3n

Open the db with 4.0 exe

twdavis

Thanks, that did it.

ara3n

you are welcome.