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.
Member for
23 years 11 months
Member for23 years11 months
Submitted by David Forrest on Mon, 2006-07-17 12:00
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.
Member for
20 years 11 months
Member for20 years11 months
Submitted by Philip Jonker on Thu, 2006-07-13 14:38
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
Member for
23 years 11 months
Member for23 years11 months
Submitted by David Forrest on Thu, 2006-07-13 09:12
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.
Member for
20 years 11 months
Member for20 years11 months
Submitted by Philip Jonker on Wed, 2006-07-12 17:28
Member for
20 years 11 monthsRE: Merging P3e Databases (R5.1)
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.
Member for
23 years 11 monthsRE: Merging P3e Databases (R5.1)
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.
Member for
20 years 11 monthsRE: Merging P3e Databases (R5.1)
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
Member for
23 years 11 monthsRE: Merging P3e Databases (R5.1)
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 & UDFs
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.
Member for
19 years 8 monthsRE: Merging P3e Databases (R5.1)
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.
Member for
20 years 11 monthsRE: Merging P3e Databases (R5.1)
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
Member for
19 years 5 monthsRE: 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