Upgrade from 2009 to 2013 - delete forms in range 30000000

Sam_Morris

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!

Sam_Morris

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

I like the idea (thanks) but why not delete in sql?