At the moment I’m planning to do a export and import from my test SharePoint farm to the customers test farm. On previous projects I was always able to build the complete SharePoint farm directly at the customer site, now that was not possible. First I thought that this could be done with stsadm backup and restore. This is not the best option because one can not control the backup (I don’t want the security settings in the backup for example) so I had to use some other command. Someone suggested to use stsadm export import. I’m not familiar with this command so I searched the internet and came up with this site, Chris O’Briens Blog. Also this blog is very useful for information about all the export/import commands.In the next couple of days I shall test the export and import on one of our test farms. I’ll keep you informed. To be continued…
Tags: stsadm
October 17th, 2008 at 8:39 AM
Howdy
I had a similar issue with prject professional on WSS 3.0 and Sharepoint and Project Server 2007.
To copy projects from one server to another I had to :
((1) Extract project from source server using Project Professional 2007.
- save as MPP file. Do this for all projects to be copied/moved.
(2) Extract the Workspace from the target machine:
Stsadm –o export –url “http:///PWA/
”:\
\.cab” –includeusersecurity
-filename “
This will save the site as a single cab file.
(3) Copy the exported cab file from (2) to target server.
(4) Delete the project and its site from the server if it already exists – go to :
PWA\Server Settings\Database Administration\Delete Enterprise Objects
On the page choose the following :
Projects, Proposals and Activities radio button
in the list. Highlight the whole line by clicking in the box just to the left of the
.
Delete Projects from Draft and Published databases radio button.
Check the “Delete the associated Windows Sharepoint site” checkbox
Check the checkbox next to the
Now go back to PWA and confirm the project and its workspace is no longer listed.
(5) Now import the site to the destination server. This will create a home for the project we are loading from the MPP file we exported earlier.
Stsadm –o import –url “http:///PWA/
” –filename “:\
\.cab” -includeusersecurity
(6) Do IISRESET from command prompt.
(7) Go to PWA then Site Actions\Site Settings\Sites and Workspaces. Confirm the site has been created. You should see the site name in the left hand column if it created OK.
(8) Go to :
PWA\Server Settings\Operational Policies\Project Workspace Provisioning Settings.
Under Automatic Provisioning, just while we are importing the project from the MPP file, set the provisioning to “Allow users to manually create….”
Click save button. ( we will switch this back to automatic after the project is saved to the server).
(9) Go to client PC. Open the MPP file from disk.
(10) Select File, Save As……. etc – this will be the same as it was on the source server.
Put in
Click Save button. ( NOT “Save As” button )
(11) Now go to File, Publish……
(12) Now go to File, Close. When asked if you want to check the project in click “Yes”
(13) Choose “Do not create a workspace at this time” – this is because we have created the workspace using the Import, and do not want to overwrite it.
Click “Publish”.
(14) Go to PWA\Server Settings\Operational Policies\Project workspaces
(15) Find the
(16) Scroll up to the top of the page and choose “edit Site address” button. This will allow the linking of the Project from the MPP file and the site we imported.
(17) Type in the site address in the “Site URL” line . This will bein the format e.g. PWA/TEST2
PWA/
You will see the URL appearing as you type.
Click OK button.
(18) Find the in the list. Highlight the whole line by clicking in the box just to the left of the
.
(19 ) Go back up to the top of the page and click Synchronise.
This synchronises the PWA security and users to the imported site and the project.
(20) From command prompt window, do IISRESET
(21) Now go to PWA\ and open the
and test all aspects of the project including PCRs, Issues and Risks.
By the Grace of God - success!!
Wazza from Oz.