Upgrade from 2009 to 2013 - delete forms in range 30000000

Sam_Morris
Sam_Morris Member Posts: 32
edited 2013-10-15 in NAV Three Tier
Hi,

I am doing an upgrade from NAV 2009 to NAV 2013. One of the first steps is to open the 2009 database in 2013. Before I can do this however I need to delete obsolete object types (forms, dataports r.i.p).

The trouble I am having is that some of the objects are in the range 30000000.. I cannot delete these even with our developer's license. ](*,)

I've tried the trick of creating empty objects with the same number in another database, but this doesn't work as you still get license permission errors.

Does anyone know how to get rid of these forms?

Thanks!

Comments

  • Sam_Morris
    Sam_Morris Member Posts: 32
    I managed to find a solution. A SQL script like the following fixed it for me:

    UPDATE [database].[dbo].[Object]
    SET [ID] = 99999
    WHERE ID = IdNo AND
    Type = 2

    Where database is the NAV database and IdNo is the object ID. You can then manually delete the table in Object Designer. If you change the Type this should work for other object types as well. I was then able to open my NAV 2009 database in NAV 2013

    Not keen on these kinds of things though, so if anyone knows a better solution ...
  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    I like the idea (thanks) but why not delete in sql?

Categories