Restore tables structure on upgrade process

mihai.valcea

Hi,

I'm actually doing upgrade from 3.6 to 4.0 and I encountered a problem.

On specific upgrade step is required to restore 3.6 customised objects on 4.0 database. This is ok but not with tables that contains data inside. The import procedure of tables crash because try to modify something on tables that contain data.

Is any solutions to rhis issue ?

thanks.

2tje

The standard Navision upgrade tools only work for standard Navision.
If you have made any changes, like changing primary key, of datatype of a field, you have to merge the custimezed 3.60 object with the standard 4.0 field. Actually you have to merge every object that has been changed in the old version (3.60 in this case) with the new standard 4.0 version.
You can use the Developers toolkit for this. But my experiences with it is that that it not always works ok and it is a lot of hassle (at least it was some years ago).
A tool that is used a lot is Beyond Compare. You export the objects from both version to text files and compare them. You copy the customizations from 3.60 to the 4.0 objects and use these objects to import into the new upgraded database.
Hope it is clear how Navision upgrades work.

mihai.valcea

Thanks for reply.
I have merged before the objects, tables especially.
The problems are with data inside tables and I tryied to use the upgrade tool to migrate the data. This no working.

Thanks

2tje

I think somewhere in the upgrade tool it says you can use the Developers Toolkit to merge the objects. Navision only provides the procedure to upgrade the standard.