none
How to migate Project server data across DEV and TEST environments RRS feed

  • Question

  • Hi,

    I am using P12 with SP1.

    I have created two PWA instances ie for DEV and TEST .Now the task is to move the data in the development instance to test instance.

    Can any one provide me the steps to achive this task.

    Regards,

    Sudhir

    Wednesday, October 6, 2010 3:07 PM

Answers

  • Hello Sudhir

    If you only interested in moving the configuration settings, there is a tool in CodePlex call "PlayBook" that manages this.

    If you interested in moving all the data, then I would backup the big four databases from Dev and restore to TEST.

    Cheers

    Michael Wharton


    Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com
    Wednesday, October 6, 2010 3:12 PM
    Moderator
  • Central Admin - Farm Backup.  Move the databases, then Farm Restore.
    Through PWA - follow Mike's advice.  Move the Draft, Published, Archive and
    Reporting databases from DEV to TEST.  Go into the SSP and reprovision a
    new PWA site by pointing it at the existing databases.  That will move all
    of your Project Server data.
     Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 3:42 PM
    Moderator

All replies

  • A couple of options....
     
    1) Do a farm backup/restore from DEV to TEST.
    2) Reprovision Test with the PWA databases from DEV
    3) Set up new data in TEST and deploy the changes.
     
    What data specifically are you moving?  And why are you moving from DEV to
    TEST?  Shouldn't you periodically refresh from PROD to TEST and then apply
    the changes from DEV?
     Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 3:11 PM
    Moderator
  • Hello Sudhir

    If you only interested in moving the configuration settings, there is a tool in CodePlex call "PlayBook" that manages this.

    If you interested in moving all the data, then I would backup the big four databases from Dev and restore to TEST.

    Cheers

    Michael Wharton


    Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com
    Wednesday, October 6, 2010 3:12 PM
    Moderator
  • Hi Andrew,

    The exact task is that I need to move data from one PWA instance to another PWA instance.

    let me know how this is achieved from sql server or from Central Admin site.

    I want the data to be exactly the same..including resource ids, all GUIDs...etc.

    Please suggest.

     

    Regards,

    Sudhir

     

    Wednesday, October 6, 2010 3:30 PM
  • Central Admin - Farm Backup.  Move the databases, then Farm Restore.
    Through PWA - follow Mike's advice.  Move the Draft, Published, Archive and
    Reporting databases from DEV to TEST.  Go into the SSP and reprovision a
    new PWA site by pointing it at the existing databases.  That will move all
    of your Project Server data.
     Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 3:42 PM
    Moderator
  • HI Andrew,

    The exact task is to move complete data from one PWA instance to another PWA instance.I want the data in both the pwa instances to be same.

    please suggest how to achive this either by SQL server or by CENTRAL ADMIN site.

     

    Regards,

    Sudhir

     

    Wednesday, October 6, 2010 4:04 PM