250 likes | 615 Views
About me. Feng ChenSenior Programmer Analyst, OACIS Platform team , S.D.O.TELUS Health SolutionsFeng.Chen@telus.com. Worked on various OACIS platform components that are used by all applicationsThe most recent focus in the past year has been on database schema and Sybase 15. Why Sybase 15. The
E N D
1. SYBASE 15
2. About me Worked on various OACIS platform components that are used by all applications
The most recent focus in the past year has been on database schema and Sybase 15
3. Why Sybase 15
4. Upgrade Procedure Overview
7. Increase Hardware Resource Requirements
8. Test/Development of Upgrade On Development Machine
9. Upgrade: Data Migration multiple approaches How to upgrade one ASE in isolation, from 12.5 to 15.5
Approach #1: Dump & Load
Approach #2: Data transfer with Quiesce & Mount
Approach #3: Unmount & Mount (in place upgrade)
Approach #4: Sqlupgrade (in place upgrade)
Considerations:
Ability to back out
Speed
10. Test Upgrade on Replicated or Standby Server
23. Upgrade: Design and Implement Your Test Plan
24. Post Upgrade Tasks
25. Thank you! Questions?