Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Enough is enough with MS-SQL!

3 replies [Last post]
Thu, 2009-04-16 11:07
Mr. Barakat
User offline. Last seen 13 years 18 weeks ago. Offline
Joined: 8 Jun 2008
Posts: 9
Groups: None
I’m suffering too many troubles with P6 based on SQL, strange error code messages which results in exit and terminating the interface and loss some date and layouts.

I guess that; It’s about the connection establishment with the SQL server, although I’m using local-server.

Now, I know that; P6 can be configured to be working with SQL and Oracle, the first platform is provided with the installation CDs to be installed first then configuring the database to be created on the SQL server.

My question is; what I have to do in order to create my database based on Oracle platform instead of SQL, and how can I switch between them?

Do I miss understand such topics? Please advice.

Best Regards,
Top

Replies

Tue, 2009-04-21 16:12
#1
mimoune djouallah
User offline. Last seen 5 years 10 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
"You have the option of creating an Oracle database instead of MySQL when you do a new install " you mean MSSQL,

but anyway ORACLE has just bought Sun which own MySQL, who know perhaps next version of Primavera will support MySQL, ;)

happy planning
Top
Tue, 2009-04-21 11:40
#2
Michael Ridino
User offline. Last seen 14 years 48 weeks ago. Offline
Joined: 21 Apr 2009
Posts: 19
Groups: None
You have the option of creating an Oracle database instead of MySQL when you do a new install.

I don’t believe you can convert a SQL database to Oracle but you will be able to export all of your data to one XER and import it into the new database. Just hope it isn’t too big or you have a lot of baselines.

Mike
Top
Thu, 2009-04-16 17:55
#3
Benjamin Mora
User offline. Last seen 11 years 10 weeks ago. Offline
Joined: 19 Oct 2007
Posts: 66
Groups: None
Why don’t you call Primavera and have them walk you through? Or, Primavera usually has literature with screen shots that takes you throught the process.
Top