I have raised this question but I want to more specific and explain the complete situation.
- There are many pages say around 3000.
- There are many publication targets. Each developer has a target created.
I am doing Porting from one environment to another environment. The porting has not been done for long time. I want to move all pages under root to another newly created structure group so that old pages do not create confusion.
Out of Box functionality does not allow me to do this easily because all the pages are published.
If I could change the publish state of pages to unpublished (maybe directly in the database or through a Core Service program), then it would be possible to move those pages.
It would be really great if someone can help with me with following:
1. Changing the publish state of pages to unpublish in a structure group recursively say directly from root.
2. Its impacts.
I browsed regarding this and I got to know from [here][2]
that we can update in database, This updates all items in a publication. But if we want to do it for a page how can we do it.
UPDATE ITEM_STATES
SET STATE = 0
WHERE (PUBLICATION_ID = ##)
I am using SDL Tridion 2011 SP1 and database is SQL database 6.1.0.996
Thank you for all the support.