You need P6, which comes with SQL Server Express 2005, to do that locally.
The installation disc (CD1) contains DB utilities allowing you to create (additional) PMDBs, also under the same SQL Server.
Hope this explains.
Niek.
P.S. It could probably also work with a full P5 with MSDE as well, but I never got that going. The problem with MSDE is that you are almost working in the blind.
Member for
18 years 6 months
Member for18 years6 months
Submitted by Dennis Hanks on Mon, 2007-11-05 17:29
Thanks. Since the schedules should be fully developed, I lean towards option 2. If I am not asking too much, could you outline how to setup the "separate instance"? I am not seeing that in Contractor. Again, thanks.
Member for
20 years 7 months
Member for20 years7 months
Submitted by Niek Zonneveld on Mon, 2007-11-05 17:06
If you set up your EPS, RBS, OBS, CAS with the proper hierarchy you can run multiple environments within one DB instance. I do the same and it works quite well.
The alternative is to create a separate instance for each client. At login you can just connect to the client you desire and work in a completely segregated environment. I use that for one client as well, but the drawback is that you need to export layouts, reports, and other enterprise data from one instance to another if you want to reuse your work. The advantage is that you are likely to make less errors, and your EPS, RBS, etc will be more "flat".
Member for
18 years 1 monthRE: P6 Multiple databases
Hi Niek.
I though that license agreement will be based on database, not server. If you buy 10 license and create 10 database, you can use up to 100 license.
Member for
20 years 7 monthsRE: P6 Multiple databases
As long as you keep your databases in the same SQL Server there is no license issue.
Cheers,
Niek.
Member for
18 years 1 monthRE: P6 Multiple databases
Hi,
If you decide to work on multidatabase ,be careful with Primavera license agreement .Cause Primavera only allow license to be install on 1 database.
Thanks
Member for
20 years 7 monthsRE: P6 Multiple databases
Yeah
You need P6, which comes with SQL Server Express 2005, to do that locally.
The installation disc (CD1) contains DB utilities allowing you to create (additional) PMDBs, also under the same SQL Server.
Hope this explains.
Niek.
P.S. It could probably also work with a full P5 with MSDE as well, but I never got that going. The problem with MSDE is that you are almost working in the blind.
Member for
18 years 6 monthsRE: P6 Multiple databases
Niek;
Thanks. Since the schedules should be fully developed, I lean towards option 2. If I am not asking too much, could you outline how to setup the "separate instance"? I am not seeing that in Contractor. Again, thanks.
Member for
20 years 7 monthsRE: P6 Multiple databases
Hi Dennis,
This is all about structure.
If you set up your EPS, RBS, OBS, CAS with the proper hierarchy you can run multiple environments within one DB instance. I do the same and it works quite well.
The alternative is to create a separate instance for each client. At login you can just connect to the client you desire and work in a completely segregated environment. I use that for one client as well, but the drawback is that you need to export layouts, reports, and other enterprise data from one instance to another if you want to reuse your work. The advantage is that you are likely to make less errors, and your EPS, RBS, etc will be more "flat".
Hope this helps.