Primavera (MOSC)

MOSC Banner

On migrating Primavera P6.7 SP2 SQL database to a P6.7 SP2 Oracle database-what are the pros and con

edited Jul 6, 2012 2:36PM in Primavera (MOSC) 1 commentAnswered
Hi All,

We have a large Primavera P6.7 SP2 SQL database with 8 PM schema that seems to be having a lot of issues recently. At present I am managing about 155 concurrent Users in that database from all over Canada and US.  Someone has recommended that changing from an SQL to an Oracle database platform will bring more data security.  It will also address the unusually slow process we are experiencing in SQL.  For example, in Primavera SQL database, copying a project file of 5000 activities takes about 10 to 15 minutes. This is just unacceptable.  We were informed that Oracle will solve this.  Is this true?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center