none
Migrate a workspace site from 2007 to 2010? RRS feed

  • Question

  • Hi guys,

    Just want to know if it is possible to somehow migrate 1 project workspace site from Project Server 2007 to Project server 2010?

    Is there an export/import command that can be used?


    Sid Kothari | MCITP, SharePoint 2010
    If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful"


    Thursday, May 10, 2012 4:04 AM

All replies

  • Hi Sid--

    As far as I know that you cannot migrate a single project workspace data of projects erver 2007 on a project site of PS2010. The best & quick would be to do a manual data migration of the Projct Server linked entities (risks, issues, documents etc) copying from one environment to the other. Unfortunately this will cause things like history / version not to be exported.

    On another note, since the project workspace info, including the documents and their versions, etc would all be in the SharePoint content database not in the project server database so you may create a new web application on PS2010 & attach/upgarde the PS2007 content database after that you can take the site backup & restore on a new PS2010 project site using cmdlets/powershell.

    http://technet.microsoft.com/en-us/library/cc263299.aspx
    http://sharepoint.tejic.com/2011/02/04/migrate-content-db-from-sharepoint-2007-to-2010/

    Hope that helps.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, May 10, 2012 5:53 AM
  • Thanks Amit, would you say that 1 approach could be to:

    1. Create a new PWA (web application) with a new content database (Project Server 2007/SP 2007)

    2. Export/Import the existing project workspace site(s) to this new PWA.

    3. Do a database attach/upgrade to Project Server 2010/SP 2010 environment.

    What do you think?

    What happens to the links within the project sites in the new environment?


    Sid Kothari | MCITP, SharePoint 2010
    If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful"

    Thursday, May 10, 2012 6:01 AM
  • Hi Sid--

    You can extract Project Web Access site content from a content database to a new content database. & later once you have the site, you can link it from PWA> Server settings> Project Sites & edit the same for the project.
    http://technet.microsoft.com/en-us/library/ee662500.aspx

    1. Identify the URL of the site collection you want to back up (for example, http://server/PWA).

    2. Use the following Stsadm command to back up the site collection:

      Stsadm -o backup -url <SiteURL> -filename <FullPathToBackupFile>

      For example: Stsadm –o backup –url http://server/pwa -filename c:\temp\backup.bak

    3. Use the following Stsadm command to create a new content database in your second Web application.

      Stsadm.exe -o addcontentDB -url <NewWebAppURL> -ds <SQLServerName> -dn <NewContentDBName>

      For example: Stsadm.exe –o addcontentDB –url http://server:82 -ds CorpSQL1 -dn PWAContentDB

    4. Use the following Stsadm command to restore the site collection to the second Web application.

      Stsadm -o restore -url <SiteURL> -filename <FullPathToBackupFile>

      For example: Stsadm –o restore –url http://server:82/NewPWA -filename c:\temp\backup.bak


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, May 10, 2012 6:09 AM
  • Hi Sid--

    Is your issue resolved? Let us know if you need any help or close the thread.

    Thanks,


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, June 27, 2012 7:09 AM