Upgrade 2009R2 to 2015 CU1, step delete objects

Dennis_Decoene

Hello,

I imported the CU1 upgrade toolkit and executed step one, transfer data. Now I want to run step two, delete objects, but I get an error stating that I cannot delete some objects because I do not have permission. I know why, it is because these are from an add-on we do not have permission to. (zetafax integration)

So I know what the problem is, I just don't know how to proceed with the upgrade now.

Any ideas?

Thanks.

uappel

I have the same problem. I want to upgrade a database 2009 R2 to 2015 and the old version contains much useless objects, which the first NAV partner implemented for unknown reasons to the customers database. There are hundreds of tables, forms and so on which are in an ID-range that can not be modified with my developers license. I can delete the objects directly in SQL server Management Studio, but I think that will cause more problems during the upgrade process because of possible inconsistencies?
Does anybody have ideas or experiences of how to handle that?

br
Uwe

daborg

Dennis_Decoene wrote:

Hello,

I imported the CU1 upgrade toolkit and executed step one, transfer data. Now I want to run step two, delete objects, but I get an error stating that I cannot delete some objects because I do not have permission. I know why, it is because these are from an add-on we do not have permission to. (zetafax integration)

So I know what the problem is, I just don't know how to proceed with the upgrade now.

Any ideas?

Thanks.

We have the Zetadocs addin in our ISV solution. I upgraded the database just fine by simply skipping those objects that I didn't have permission to delete. It's makes that step a bit more cumbersome as you can't simply select all of the objects, but if you do this I think your upgrade will succeed just fine.

Good luck!! \:D/

Dennis_Decoene

I solved it by doing this:

1. Make FBK of everything except objects.
2. Make FOB of everything except offending objects
3. Create new DB in 2009R2
4. Import FOB from step 2
5. Restore backup from step 1
6. Manually delete offending tables
7. Continue upgrade process

uappel

Now I found two possible ways to get rid of unwanted and not licensed objects.
As posted in a german forum I can

1) Use "killer" objects to delete the not needed objects like described here
http://navisionary.com/2011/11/how-to-d ... v-objects/
http://www.archerpoint.com/blog/Posts/killer-objects

2) delete the old objects in SQL Management Studion in the SQL tables with an SQL query
( in a new database that contains only objects, no data )
Object
Object Metadata
Object Tracking
Object Translation
User Metadata
after that the objecs should not appear anymore in the development environment.
maybe you need to fix some relations to be able to compile the left objects in the database because of missing references,
to be able to compile all objects.

br and merry christmas to all
Uwe