I am trying to migrate NAV 5.0 to Nav 2009 as part of my master thesis. Now I have run in to a problem, which is something to do with licence restrictions. In Table 49, some fields were added by a Microsoft partner (field IDs 5130220 - 5130223). After merging the table 49 using NDT, I then tried to import it as a fob to the target (NAV2009) database, but now it does not allow me to import the table, since I have no rights to create these field IDs. Has anyone come across a problem like this or has anyone got some hints for me to be able to import this table with those field IDs.
When you import the fob, select merge option and NAV will allow you to create the fields. Afterwards load the merged txt file to make sure it has been merged correctly.
If there are any code referencing the new fields they need to be comented, otherwise the merge option will error out.
Thanks for the reply, by following your instructions, it is possible to create the fields in the new table but it is a bit more complicated than I have realised it before;
When I do the merge, I have to take at least 2 tables into consideration! 1. Current company (Nav5) 2. new Base version (Cronus Nav2009). In the current company table 49 there are some fields created by the MS partners, which I do not have rights to delete as it is. And in the new Base version (Cronus Nav 2009)there are number of microsoft fields have been deleted that exist in the current company table. Now in the merged table is supposed to have fields, which the MS partners created and without the fields, which MS has deleted in the new Base version (Cronus Nav2009).
Right now I can have a merged table as fob with fields created by the MS partners and with the fields that MS new Base version (Cronus Nav2009) is supposed to have been deleted. I want to find a way to delete the Fields, which MS has deleted in new Base version (Cronus Nav2009) manually. Is there a way to remove fields, which are created by MS in the SQL server or so?
It impossible to delete such fields without apropriate developer’s licence.
But If you want to remove in 2009 there is existing not very good way. Renumber field MS IDs to the allowed range (for example 50xxx). This will work but this not very good for next upgrade.
If you need help to do it correctly plese refer to me i will try to help.