none
Upgrade ProjectServer 2013->2016->2019 RRS feed

  • Question

  • Hello guys,

    I'm finishing my first upgrade of ProjectServer and I have a question concerning the ProjectServer content database.

    Here is the situation:

    I have a 2013 farm with PWA. It contains a SharePoint content db (SPS_CDB) and a ProjectServer content db (PWA_CDB)

    I installed a 2016 farm and followed the upgrade plan (https://docs.microsoft.com/en-us/project/upgrading-to-project-server-2016):

    Attach and upgrade your SharePoint 2013 content database <-- the SPS_CDB

    Attach and upgrade your Project Server 2013 databases <-- the PWA_CDB

    At this point, the process went fine (or, I didn't receive any error - at least)

    I continued with the installation of a 2019 farm and followed the upgrade plan (https://docs.microsoft.com/en-us/project/upgrading-to-project-server-2019):

    Attach and upgrade your SharePoint Server 2016 content database <-- the SPS_CDB

    My question (and concern) is : "what happened to my Project Server database? The PWA_CDB"?

    If I compare the size of the databases, something is clearly missing:

    2013: SPS_CDB is 3GB and PWA_DB is 15GB

    2016: SPS_CDB is 3GB and PWA_DB (after migration) is 15GB (is it still used after migration?)

    2019: SPS_CDB is 3GB. No trace of PWA_DB so my feeling is that 15GB of data is missing somewhere.

    I asked the question in a premier support ticket and the guy answered me that the PWA_CDB is no longer used because the data were migrated to "another db". Which one? I don't know, nothing appeared.

    My PWA_DB is still next to the other one but even by putting it offline, nothing seems different. How could I rename it to avoid confusion?

    Can you help me figure this out? What am I missing here?

    Thanks!

    Wednesday, April 1, 2020 2:55 PM

Answers

  • Hi Michael,

    Indeed, I can find the new schemas in the migrated database (and not in the original one).

    I'm still amazed by the 15GB that disappeared as it was pure data (not transaction logs files or "unallocated space") but I guess the process is completed then.

    Thanks for your answer!

    Thursday, April 2, 2020 7:42 AM

All replies

  • After installing SP2016 and then migrating PWA_DB to SP2016, the PWA database structures are part of the SPS_CDB (SharePoint Content database and assuming you migrated data into the content databse).  Open SPS_CDB using SQL Server, there will be PWA data structures with names table names prefixed with names like prdraft, pjpub, pjrep, pjver, etc. 

    The PWA_DB is not used anymore in Project Server, and that is because it is store in the content database.  Having all the data in one database is easier to manage and data structures similar to that as project online.

    AS far as why the database is smaller;  this is because the log files and transaction data is not migrated.


    Michael Wharton, Past MVP, MBA, PMP and a Great Guy <br/> Website http://www.WhartonComputer.com <br/> Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Thursday, April 2, 2020 3:55 AM
    Moderator
  • Hi Michael,

    Indeed, I can find the new schemas in the migrated database (and not in the original one).

    I'm still amazed by the 15GB that disappeared as it was pure data (not transaction logs files or "unallocated space") but I guess the process is completed then.

    Thanks for your answer!

    Thursday, April 2, 2020 7:42 AM
  • Here's something else you can do and maybe it will make more sense.

    Compress the old PWA_DB and see how large the database is after compression.


    Michael Wharton, Past MVP, MBA, PMP and a Great Guy <br/> Website http://www.WhartonComputer.com <br/> Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Thursday, April 2, 2020 2:22 PM
    Moderator