Rod Weir wrote:
The "noise" leftover in the database after such an operation is due to DNN lack of database referential integrity and database design best practice. Would be great to see this improved over time. I've always thought that this exact scenario would be a very popular commercial module if someone was willing to make it. - The "Reportaler"
I agree, there's lots of scope for developing modules that do clean up and optmisation tasks for the database and file system. I'd walk over hot coals to get my hands on one that found orphan files in the file system!
However that sort of thing has to take second place to the front end functionality - it has ever been thus - the older shrink-wrapped software suffered from code bloat in version releases.
Would be good to see some simplification though. The level of knowledge a site admin has to have about configuring a DNN install (to get it running well) is getting a little alarming. DNN's modular format is one of the reasons I love it, but it's easy to fall into the feature bloat trap.
Back to the topic ;-)
When deleting portals from a duplicate install to separate out a particular portal, I first delete any module not in use on the new single portal install, and then write a lot of SQL to explore the tables to find the leftover information in the db so I can then very carefully delete it. The overhead of leaving that 'noise' in there isn't that high, I guess it depends on how tidy you want/need to be. Although you should always go in to the portals you are about to delete and delete all the users first (as otherwise those usernames are 'taken' in the new single portal install despite not having being registered to a portal). I do this with SQL, but it's as easy (just slower) to do from the front end.