
CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate
33
• Information on how to configure memory for performance in the
Performance and Tuning Guide at
http://manuals.sybase.com:80/onlinebooks/group-
as/asg1250e/perf/@Generic__BookView
.
Note For a production system, execute the performance suite during off hours.
Scheduling
For a development system, you may want to add a short period to the
development schedule for release 12.5 issues.
For a production system, be prepared to postpone or back off if needed.
Phased Cutover
The issues for a phased cutover are described in the following sections:
Method
Change only one application and database to release 12.5 at a time.
Fallback
Consider making daily bcp dumps of the databases. To fall back, you can then
load the dumps into the earlier server. Keep in mind:
• You may need to modify the databases to support incremental bcp dumps.
• The earlier server cannot read release 12.5 backup files. You need to create
bcp or other scripts to move tables back to the earlier server.
• Do not use release 12.5 schema enhancements until the conversion
succeeds.
For information about scheduling backups of user databases, see the
System Administration Guide at
http://manuals.sybase.com:80/onlinebooks/group-
as/asg1250e/sag/@Generic__BookView
.
Application test suite
Ensure that the application test suite addresses both update correctness and
performance acceptability. Also ensure that you do the following:
• Maintain the directories/libraries for both releases.
• Make sure the applications are using the correct server.
• After successful validation, consider having users enter production queries
with the production toolset. A good time to do so is after hours or during
production lulls.
Commenti su questo manuale