1

Inside our Tridion 2011 instance, there are a lot of legacy publications with huge number of published components and pages. We created a C# tool based on Tridion core service API to un-publish / unlocalize / uncheckout and delete them. But the relationship is too complex and size is too big. After more than 5 days continues running there are still more than a half items not be cleaned.

Is there any SQL Script can help us safely set related item's publish status to false so we can just delete it directly?

Improve this question
1
  • It is achievable but probably no "safe" way to set the item's publish status.
    – Shiva
    Commented Oct 18, 2016 at 14:24

2 Answers 2

Reset to default
2

You are probably best speaking to SDL Support about this. They are the only ones who would be able to provide a SQL script that would still leave your implementation fully supported afterwards.

Improve this answer
3
  • Even when provided by SDL support, DB-level modifications are not supported.
    – Rick Pannekoek
    Commented Oct 18, 2016 at 17:34
  • Rick, that's good to know. Thanks for the information.
    – Jonathan Williams
    Commented Oct 18, 2016 at 18:37
  • That's very nice to know the DB level modification is not supported. Thanks.
    – qchen01
    Commented Oct 18, 2016 at 18:39
1

Consider upgrading to SDL Web 8 (or 2013 SP1). Those versions provide functionality to "decommission" Publication Targets, i.e. to "forget" publish state of items.

Improve this answer
3
  • Thanks Rick. If we migrate from 2011 CMS DB to WEB8 DB directly, will the publish status be kept? If not, can we just leave it like this, then delete them after migration?
    – qchen01
    Commented Oct 18, 2016 at 18:39
  • For the decommission feature, will it affect all items be published to that targets? Since we have 20% publications need to be delete, but still want to keep the other 80%. They share the same publish targets.
    – qchen01
    Commented Oct 18, 2016 at 18:43
  • Normally, decommissioning applies to all Publicatioms, but IIRC you can create an event handler to interfere with the resolving.
    – Rick Pannekoek
    Commented Oct 18, 2016 at 18:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.