How to delete "out of license" tables

StLi · 2016-05-27

Hi!

We're the new Solution Center for a customer whos old SC went out of business. One of our customers first requests is/was to upgrade to 2016 (currently 2009 R2) and switch to our business solution. Which requires to remove the old - unused - Code & Objects of the former Solution Center.

It was decided that we want to realize this in a "regular" upgrade project instead of importing and exporting the Data from the current into the destionation DB. So, we actually need to delete the old objects from the current DB which is pretty easy for most Object types thanks to the so called "Killer Objects" as mentioned here: http://www.archerpoint.com/blog/Posts/killer-objects

However, there are some tables which are completely out of our license range and we want to get rid of them. Partly, because we want to have a clean database and also, because we have some tables in our own business solution with the same names. As you might know, navision doesn't allow us to have two objects of the same type and name in their DB.

My question now is: is there any way to generate those killer objects for tables out of our license? or at least a way to rename the tables?

Thanks for your help

StLi

p.s. We are aware of this here as well - doesn't work with tables though :-(: http://navisionary.com/2015/08/how-to-delete-obsolete-dynamics-nav-objects-version-2/

StLi · 2016-05-27

Update: I figured out that it works if i use the same SQL commands on a 2013 DB but it didn't work on the 2009 i tried it on in the first time. - Followup question: I was able to knock out most of the unwanted tables with my killerobjects. however on three of those tables, the client crashes whenever i try to delete them with hte killerobjects they were right between other tables that were deleteable Id-wise spoken. I don't really have a clue what the problem might be. Unfortunately i can't edit the tables to check their properties.

mdPartnerNL · 2016-05-27

do a search here for a sql script

StLi · 2016-05-27

ah i just though this might come up so i edited the initial post.. unfortunately tables created with the SQL injection can't be exported. So we can't use them as Killer objects. and with C/AL the license is in the way.

StLi · 2016-05-27

Update: I figured out that it works if i use the same SQL commands on a 2013 DB but it didn't work on the 2009 i tried it on in the first time. - Followup question: I was able to knock out most of the unwanted tables with my killerobjects. however on three of those tables, the client crashes whenever i try to delete them with hte killerobjects they were right between other tables that were deleteable Id-wise spoken. I don't really have a clue what the problem might be. Unfortunately i can't edit the tables to check their properties.

How to delete "out of license" tables

Best Answer

Answers

Categories