none
Project Professional 2010 location of Enterprise Global RRS feed

  • Question

  • I would like to transfer only some of the tables and views from a Enterprise Global in one project server instance say pwa1 to the Entrerprise Global of a new project server instance pwa2. Where do I find the physical location of (in file system ) of  Enterprise Global  of the first  instance pwa1 to copy the specific tables and views of the second instance through organizer?

    What would be the best way to copy specific tables and views to from Enterprise Global of pwa1 to pwa2 without messing up the existing entrprise global of pwa1 !!!

    Also where is the Enterprise Global file saved when we back-up it through server settings. Is there a copy of it in the file system?


    • Edited by geeam Monday, November 24, 2014 8:56 AM
    Monday, November 24, 2014 8:50 AM

Answers

  • Hello,

    The Enterprise Global settings are stored in the database but are not readable, you need Project Pro. When a backup runs, a copy of the settings are stored in the Archive database schema.

    All of the fields are referenced using the GUIDs in the Enterprise global so unless PWA1 and PWA2 has the same field GUIDs, what you are trying to do wont work.

    Assuming the GUIDs were the same, the steps are like the steps below:

    • Test these steps on replica non-production PWA instances first
    • Backup the Enterprise Global for PWA1
    • connect to PWA1 using Project Pro  and open the Enterprise Global from the File > Info > Organizer menu option
    • Using the organizer copy the entities that you want to copy over to PWA2 into a project file. Copy from the "checked-out Enterprise global" to the project
    • Close the Enterprise Global for PWA1 without saving
    • Save the project file locally as an MPP file
    • Backup the Enterprise Global for PWA2
    • Close Project Pro and connect to PWA2, close the blank project and open the project file containing the Enterprise Global entities from PWA1, now also open the Enterprise Global for PWA2. Open the organizer and carefully copy over the Enterprise Global entities from PWA1 in the project file to the "checked-out Enterprise Global" in PWA2. Be careful not to copy over local entities etc.
    • Save the Enterprise Global in PWA2 and close/ check it in
    • Close Project Pro and re-connect to PWA2
    • Fully test to ensure all works as expected. If it doesn't, restore the backup of the Enterprise Global for PWA2.

    Before carrying out these steps, ensure you have full backups etc. Ideally test this on a non production farm / instances first!

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads


    Monday, November 24, 2014 9:11 AM
    Moderator

All replies

  • Hello,

    The Enterprise Global settings are stored in the database but are not readable, you need Project Pro. When a backup runs, a copy of the settings are stored in the Archive database schema.

    All of the fields are referenced using the GUIDs in the Enterprise global so unless PWA1 and PWA2 has the same field GUIDs, what you are trying to do wont work.

    Assuming the GUIDs were the same, the steps are like the steps below:

    • Test these steps on replica non-production PWA instances first
    • Backup the Enterprise Global for PWA1
    • connect to PWA1 using Project Pro  and open the Enterprise Global from the File > Info > Organizer menu option
    • Using the organizer copy the entities that you want to copy over to PWA2 into a project file. Copy from the "checked-out Enterprise global" to the project
    • Close the Enterprise Global for PWA1 without saving
    • Save the project file locally as an MPP file
    • Backup the Enterprise Global for PWA2
    • Close Project Pro and connect to PWA2, close the blank project and open the project file containing the Enterprise Global entities from PWA1, now also open the Enterprise Global for PWA2. Open the organizer and carefully copy over the Enterprise Global entities from PWA1 in the project file to the "checked-out Enterprise Global" in PWA2. Be careful not to copy over local entities etc.
    • Save the Enterprise Global in PWA2 and close/ check it in
    • Close Project Pro and re-connect to PWA2
    • Fully test to ensure all works as expected. If it doesn't, restore the backup of the Enterprise Global for PWA2.

    Before carrying out these steps, ensure you have full backups etc. Ideally test this on a non production farm / instances first!

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads


    Monday, November 24, 2014 9:11 AM
    Moderator
  • Thanks a lot Paul for your quick response, which is immensely helpful. When I am copying required entities from existing Global Enterprise in pwa1 to a new project1 file, for two of the tables and consequently for its views the copy button is getting greyed out. For others it is working fine. What should be done in this case to activate the Copy button.

    Also for some of the tables when trying to Copy gives message :

    "The task table 'tableName' already exists in Project1.

    Do you want to replace the task table 'tableName' in 'Project1' with the task table tableName from "Global (+non-cached Enterprise)"?"

    What should be response as the tableName did not exist in Project1 before?

    Monday, November 24, 2014 9:43 AM
  • I'm not sure why the copy button is greyed out for two of the tables, ensure you are trying to copy from the "checked-out Enterprise global" and only trying to copy Enterprise entities.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads


    Monday, November 24, 2014 9:54 AM
    Moderator