Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Merging P3e Databases (R5.1)

7 replies [Last post]
Wed, 2006-07-12 10:27
David Forrest
User offline. Last seen 1 year 6 weeks ago. Offline
Joined: 27 Nov 2001
Posts: 104
Groups: Accreditation Editors, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Sarawak Primavera User Group (SPUG)
I am using two databases to service different divisions within the same organisation and plan to merge both databases into a single instance. This involves moving 70+ users, 170 portfolios and over 3600 projects from one database into the other. The structures, OBS EPS, Resources etc are similar but there are thousands of project and activity codes, a few are common.
The only method that I am aware of to implement this is to rebuild the host database, users, access privileges etc then export/import by portfolio.
This means rebuilding filters, layouts, reports etc, a horendouse task.

Anyone tried to merge databases?
Top

Replies

Mon, 2006-07-17 14:25
#1
Philip Jonker
User offline. Last seen 16 years 34 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi David,

I Think it is possible, send me a private message, and we could organise a video conference. I have people, besides myself who can assist you, if not so be it, a small amount of time lost, otherwise me might be able to resolve your problems in a very pragmatical way.
Top
Mon, 2006-07-17 11:00
#2
David Forrest
User offline. Last seen 1 year 6 weeks ago. Offline
Joined: 27 Nov 2001
Posts: 104
Groups: Accreditation Editors, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Sarawak Primavera User Group (SPUG)
I note your comments, however, I totaly disagree with your timescales. I am dealing with 3600 projects spread throughout central engineering headquarters, 8 nuclear power stations, also converting from R4.1 to R5.1 then importing into an infrastructure that is not yet fully tested. Also need to consider continuous work for the planners, thus the reason for dealing with exporting/importing by portfolio.
Top
Thu, 2006-07-13 13:38
#3
Philip Jonker
User offline. Last seen 16 years 34 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi David,
I think you are over reacting, you have to sit quietly and think the process through, work out all the pitfalls, which will take about a week and then get stuck in. The exercise will probably take less than a week. Work out the simplest ways, have been through this problem already.

Regards

Philip
Top
Thu, 2006-07-13 08:12
#4
David Forrest
User offline. Last seen 1 year 6 weeks ago. Offline
Joined: 27 Nov 2001
Posts: 104
Groups: Accreditation Editors, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Sarawak Primavera User Group (SPUG)
Reason for posting was to establish if anyone had tackled this issue, my plan is:-

V5-Migr Migration of Db
V5-Migr.DB Database Configuration
V5-1000 Review Host Db Configuration
V5-1050 Compare Db Configurations
V5-1100 Synchronise Db Settings
V5-1105 Migrate one portfolio and test sample reports against V4.1 results
V5-1150 Update Process Documentation
V5-1200 Database Settings Complete
V5-Migr.DBP Prepare Host DB
V5-1250 Update EPS
V5-1300 Update OBS
V5-1350 Add Project Codes & UDF’s
V5-1400 Add Activity Codes
V5-1450 Add Resource Codes
V5-1500 Add Resources
V5-1600 Database Coding Complete
V5-Migr.DBP.OT1 Host Db Integrity Tests T B A
V5-Migr.REP Configure Layouts & Reports
V5-1650 Recreate Filters
V5-1700 Migrate (export/import) Layouts
V5-1750 Migrate (export/import) Reports
V5-1800 Reconfigure and test Filters, Layouts & Reports in Outage Db
V5-1850 Database Ready For Projects
V5-Migr.PM Portfolio Migration
V5-1860 Confirm Ownership of all Schedules
V5-1900 Produce Plan For Data Migration by Portfolio
V5-1950 Build Portfolios in Outage Database
V5-2000 Migrate 170 Portfolios & 3673 Projects into Database (5 per day)
V5-2050 Test Layouts and Reports
V5-2100 Data Cleanse
V5-2150 Database Merger Complete

My etimate is 120 days of effort to do the conversion and 3 months in a rest home to recover!!!!

Would like to hear if anyone has a better idea.

Top
Wed, 2006-07-12 17:47
#5
Barrie Callender
User offline. Last seen 2 years 11 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 39
Groups: None
The effort and time it will take really depends on the state of your databases and your ability touse tha Integration API to export and import data using the business rules.

Yuo really need to have a good look at the databases to see what is different and what "merge" really means.
Top
Wed, 2006-07-12 16:28
#6
Philip Jonker
User offline. Last seen 16 years 34 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi David,

Make sure you convert all your structures to global before you try and converge, and check you haveno conflicting codes,should be a painless process
Top
Wed, 2006-07-12 10:35
#7
Nigel Winkley
User offline. Last seen 1 year 14 weeks ago. Offline
Joined: 11 May 2006
Posts: 187
Groups: The GrapeVine
David

A company I worked for - and I had better not say who - tried it and ended up having to start again from the original data restored from backup.

That was 30 odd users, 9 nodes, 250 portfolios and probably about 1000 project.

My only comment good luck and have you made a backup?!

Hope someone else can give guidance - sounds like a job and a half.

Cheers

Nige
Top