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.

transfer EPS from P3e to P6

11 replies [Last post]
Wed, 2008-10-22 05:49
tamer sayed
User offline. Last seen 15 years 27 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 38
Groups: Petro-Chem / Oil & Gas
dear friends
does any one know can i transfer EPS from P3e to P6

i worked before on P3e i created before EPS not i want to install P6 what can i do to transfer this EPS from P3e to P6

Note :-
i try used with Export from P3e to P6 and import using P6
but with this way i should export 1 project per time

if any one have any solution please let me know
thank you
Top

Replies

Thu, 2008-10-23 05:29
#1
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Tamer
Sorry, I don’t know this file ssmee.exe.
Regards
Dieter
Top
Thu, 2008-10-23 04:54
#2
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Tamer
The data model is the same under ORA and MS SQL. For an upgrade from one to the other you’ll need a specialist from your Primavera rep. For upgrade have look into your CD no.3 Documentation --> technical ... --> manual upgrade.
Within the technical documentation you can find the schemas of all tables and a printout in A0-format of the data model.
For the EPS have a look into the table PROJECT, data item "project_flag", which indicates if a record idenfities an EPS-node or a project.
Hope that helps!
Dieter
Top
Thu, 2008-10-23 03:34
#3
tamer sayed
User offline. Last seen 15 years 27 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 38
Groups: Petro-Chem / Oil & Gas
Dear Sir.
our database working under ORACLE
so could you please let me know which file i can use to transfer EPS from P3e to P6
Top
Thu, 2008-10-23 03:33
#4
tamer sayed
User offline. Last seen 15 years 27 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 38
Groups: Petro-Chem / Oil & Gas
Dear Sir
could you tell me what i will do after i find this file ssmee.exe
i found this file ion my pc cause i use SQL in my pc but tell me how can i use it

but i can not find this file on my pc in job cause my company use Oracle system

So could you please which file i will use in Oracle System to copy EPS

Thank you
Top
Wed, 2008-10-22 09:01
#5
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Tamer
In Most installations the EPS isn’t big. It’s faster to type in the new db than to write a script. For a script you’ll need IT and access to to (AND knowledge of) Enterprise Manager.
Dieter
Top
Wed, 2008-10-22 08:06
#6
tamer sayed
User offline. Last seen 15 years 27 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 38
Groups: Petro-Chem / Oil & Gas
ok thank you
but please tell me how can i reach for database file to transfer EPS
really i am in critical position
please help me in this subject
tell me in steps please
i can do every thing
and no IT here
i do all jobs
if i can not do this may be it will be not good for me
thank you
Top
Wed, 2008-10-22 07:57
#7
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Tamer
No disturb. If you’ll open more projects you can export them in one file. just select all projects within the export wizzard.
Dieter
Top
Wed, 2008-10-22 07:54
#8
tamer sayed
User offline. Last seen 15 years 27 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 38
Groups: Petro-Chem / Oil & Gas
Xer files contain 1 project only
if i export more projects in export screen i should click in only 1 project

any way tell me how can i transfer many projects by xer files

thank you
sorry for distribing
Top
Wed, 2008-10-22 07:13
#9
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Tamer
Among your installation CD’s on the first you can find the script for update from previous version. CD 3 is the documentation CD with an admin manual. Please read this first. If you don’t understand, it will be better to let your IT staff do it or to enter EPS and OBS by yourself. The risk to destroy data would be too big.

XER file can contain many projects.

Good luck!
Dieter
Top
Wed, 2008-10-22 06:33
#10
tamer sayed
User offline. Last seen 15 years 27 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 38
Groups: Petro-Chem / Oil & Gas
Dear Sir
thank you for your sooner replay
could you please tell me steps in details
cause i do not know more about primavera and database
so please tell me from where this scripts and readme
thank you
Top
Wed, 2008-10-22 06:02
#11
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Tamer
P6 is the current version of P3e. On your cd’s you can find scripts to upgrade your database to P6.
Study the readme-files first!
It is not possible to migrate directly from P3e 4.1 to P6. Even P6 and P6.1 has a different database - and the migration requires an upgrade.
Good luck!
Dieter
Top