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.

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.

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) PMDB’s, 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.

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

As long as you keep your databases in the same SQL Server there is no license issue.

Cheers,

Niek.

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.