Where are Primavera's old baseline dates stored after rescheduling the project?

Question

Any idea Where are Primevera's old baseline dates are stored after rescheduling the project? We can see the old dates in the Client but I want to query the database to get all the dates which were used before the current baseline dates.

Answer 1

Check this LinkedIn thread for same question and discussion. See the post by the user Gene Greiff, which contains the following code:

Declare @BaseLineName varchar (255) 
Declare @BaseLineType varchar(255) 
set @BaseLineName = 'Project Nano - B2' 
set @BaseLineType = 'Mid Project Status Baseline' 


select * 
from dbo.PROJWBS pw 
inner join PROJECT pj on pj.proj_id = pw.proj_id 
inner join BASETYPE bt on bt.base_type_id = pj.base_type_id 
where pw.wbs_name = @BaseLineName 
AND bt.base_type = @BaseLineType