P6 Multiple databases
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
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.
As long as you keep your databases in the same SQL Server there is no license issue.
Cheers,
Niek.
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
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.
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.
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.