It is common to create multiple websites in a single instance of Microsoft Content Management server 2002 Server. Usually these sites share same site structure with different Content and different Skins. The simplest and efficient way to kick off a new site is to copy the child channels and posting after creating the Root channel for the New site.
For example a Pet Food company has a MCMS site for Dog Food and another website for Cat food.
Channels
CatFood
en-CA
LeftNavigation (10 Sub Channels and 50 postings)
......
TopNavigation (6 Sub Channels and 30 postings)
News (20 posting)
Now lets Say we Need to Create DogFood site
Channels
DogFood
At this point you will usually go to Site Manager and copy en-CA from CatFood to DogFood hence copying all the sub Channel as well. But all the newly copied postings will become unpublished
Here is utility from MSDN that will MASS approve all the postings for you. Just copy the ApproveAll class to a Console Application i.e Create a New Console Application and Add the file from the link below. if you have named your Console Application CmsApproveAll then you can call it
c:> CmsApproveAll -DogFood
the application will walk through all the postings in the hierarchy and approve them.
Note you need to have Rights in MCMS to approve the postings and you should be running it from MCMS Server machine itself.
Also you can use this utility to approve every thing in your MCMS site by calling it with out any parameter
C:> CmsApproveAll
Warning: You should always be carefully doing MASS approve because it overrides the usual workflow and may approve the postings that you don't want to move end users to see or if you have automatic deployment scripts then theses postings might end up in the Production Environment as well.
Here is the link the the Source Code for MASS Approval Utility:
Approve ALL MCMS Postings Source Code
Navigate down to Appendix A: Sample Application for Bulk Changes.