Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Primavera P6 v7 - move from Stand Alone to Network - MS SQL Express or ORA XE

3 replies [Last post]
Jahan B
User offline. Last seen 6 years 26 weeks ago. Offline
Joined: 25 Dec 2012
Posts: 3
Groups: None

Folks, wishing you all season's greetings, happy holidays and a prosperous 2013 to come.

My question is the following:

- Moving from Stand Alone installs of P6 v7 to a Network DB, what are your recommendations to be cost effective or efficient?

- Could this be achieved by using either MS SQL Server 2008 Express R2 or Oracle 11g Express for a total of 4 to 5 users?

- If the above is possible, which DB would you recommend as to ease of maintenance and administration?

- The limitations on both the MS and ORA 'Express' DBs, will they pose problems/bottlenecks for a group of users that are all based in the office?

Thank you,

Jahan

Replies

Jose Frade
User offline. Last seen 2 days 2 hours ago. Offline
Joined: 7 Jun 2005
Posts: 144
Groups: None

Hi,

Agreed with the choise of MS SQL.

Concerning multiuser allowed by SQL Express I already used for 5 simultaneous loged in users and no problem.....

BR

 

JMFrade

Jahan B
User offline. Last seen 6 years 26 weeks ago. Offline
Joined: 25 Dec 2012
Posts: 3
Groups: None

Hi Ronald,

Thank you for your time and informative reply.  We will venture down the MS SQL route for the single DB for our P6 users.

As you say MS SQL Express could porbably handle our requirements, I will test to see if we can allow multiple users to logon at the same time to the DB and revert.  If the single user limit gets in the way then off we go to on the full MS SQL 2008 path.

Ronald Winter
User offline. Last seen 5 years 13 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None

Jahan,

I am not quite sure how to answer your question.  There are so many layers to this question.

Firstly, MS SQL 2008 Express is superior to Oracle Express.  Oracle Express only allows for one database while MS SQL allows as many as you wish.  Multiple databases are used for things such as keeping incoming export schedules separate from the production schedules until you have had the chance to ‘scrub’ them from corrupting data.  Other uses include isolating one client’s schedules from another client’s schedules.

Secondly, Oracle Express has a limit of 4 GB in size.  Once you reach this limit, the entire database locks-up and very little can be done to fix this other than reloading a backup.   MS SQL 2008 Express, R2 has the unique ability to handle up to 10 GB of data before experiencing the same issue.  Obviously, MS SQL 2008 R2 is the superior choice.

Now for the other ‘layer’;  Both Oracle Express and MS SQL Express are licensed for only one user at a time.  While it will allow you to register more than one user, Oracle Express will not allow a second person to log into P6 while another is using it.  I am not certain if MS SQL Express acts this way, but I am certain that the license only allows for one person at a time to use it.

A third layer is performance.  Both Express database softwares are purposely limited so that multi-user hosting would be hindered.  They will only use a single CPU, regardless of how many you have in your computer.  They also limit the amount of RAM memory allowed to be accessed to also throttle back performance.

Both Oracle and Microsoft want you to purchase their multi-user (non-free) software to hose multiple users.  You will be happier if you do the right thing and look into purchasing the full version of MS SQL 2008 R2.  Good luck!