You can review the below doc id
How To Determine The Project Management (P6 Professional) Client, Database, P6 Web Access and Progress Reporter Version (Doc ID 914490.1)
Basically you can verify it from P6 Client (Click: Help, About Primavera..., About (tab)). Alternatively from the database "select database_version from prefer;"
Let me know if this is not what you were looking for,
#1. From application, go to Help -> About Primavera, and System tabe
PMDB Release 7.0 SP3 (0700.0001.0001.0003)
#2. From database
select database_version from prefer;
Was our answer helpful?
If so, highlight the information for other Community members by rating it or marking the answer as correct.
Just hit the “Correct Answer” link on the answer, or rate it by clicking "Helpful Answer" or "Like".
Thanks Sachin, Wang,
Seem that all I need to know. My software is under SP2:
About: Primavera P6 Project Management
Release: 7.0 SP2
Username: admin (Adminstrator);<Admin Superuser>
PM Database: PMDB: SQLServer (admin, .\[...])
MM Database: MMDB: SQLServer ()
Database Schema Version: PMDB,0700.0001.0001.0002
However, I check on DocID (Doc ID 914490.1), seem the database version is PMDB,0700.0001.0001.0002 does not speak a lot of thing to me coz it could be Release 7.0, or 7.0 SP1, or 7.0 SP2.
PMDB Release 7.0 SP5 (0700.0001.0001.0004) PMDB Release 7.0 SP4 (0700.0001.0001.0003) PMDB Release 7.0 SP3 (0700.0001.0001.0003) PMDB Release 7.0 SP2 (0700.0001.0001.0002) PMDB Release 7.0 SP1 (0700.0001.0001.0002) PMDB Release 7.0 (0700.0001.0001.0002)
So how can I know exactly this is the upgrade version SP2? (I just to make sure my previous guys did the upgrade the service pack for database as well)
Looking at the database alone it is difficult to conclude. However P6 client is on SP2. I think there will be compatibility issue if both database and P6 client are not on same service pack.
One way to handle this situation could be that you apply latest service packs to both database and P6 client so you are sure of the versions.
I don't think will be compatipility issue because we have a lot of users are sharing this database, some of them still using Release 7.0 and some using 7.0 SP2.
I assump that Release 7.0, 7.0 SP1, and 7.0 SP2 are compatible with PMDB,0700.0001.0001.0002; Release 7.0 SP3, and 7.0 SP4 are compatible with PMDB,0700.0001.0001.0003; and Release 7.0 SP5 is for PMDB,0700.0001.0001.0004...