Merging P3e Databases (R5.1)

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

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

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.

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.

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

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.

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.