What I learnt from this project

1. Really need to follow the project schedule as much as possible. If it is foresee that it will be delayed, then it is needed to rebaseline as early as possible.
2. From the past experience, it usually takes at least 3 days for a promotion to be completed, i.e. from the day you submitted the request in starteam to the day the promotion is done. If the PDN promotion date (Thursday) is in between the submission date and the expected completion date, then one more day is to be added.
3. Change control, though there is no guideline to when the UAT request, or PDN request to be submitted, I better set the deadline of submitting request at least 3 days before the expected date of UAT promotion and the PDN promotion. However, since there is no strict guideline on this, I may need to suffer from the delay by others.
4. For a new system, the resource planning is needed.
1. Hardware: Advise TS where how the SIT, UAT and PDN environment be structured.
2. User id: Need to apply the creation of user id in the server, application server, and the database.
3. Discuss the ownership of the id.
4. The ids are better to be ready before the vendor installed the system.
5. Control the phase of the testing.
1. Test it phase by phase.
2. Proceed to another phase after the completion of the current one. Follow the change control procedures to set up the next phase. So the migration procedures can be tested during the UAT promotion.
6. For something not sure, it is really needed to dig into it. Dun be lazy. For example, in the LMS project, the difficulties lied in setting up the DTS job. Actually, it must make sure that the SSIS workable in this scenario, so that the effort won’t be wasted on developing it.
1. Is SSIS works in the HR db (SQL Server 2000)? After this question, it is no need to think about it anymore.
2. So DTS is the only solution, do you know how to do it? No.
3. Then if there anywhere you can try it? There should be. Ask others.
4. If the required table is not existed, how will you deal with it? Set up some temp tables with similar structure. Then you can test the SQL and the program.
7. Other ppl won’t know how urgent it is, or how urgent you feel. You are the only one to push them and yourself. 正所謂你急人唔急