Phased cutover

Method

Change only one application and database to release 15.0 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:

Application test suite

Ensure that the application test suite addresses both update correctness and performance acceptability. Also ensure that you do the following:

Bridging

There should not be any user impact during migration. The more stringent the validation test is, the less likely you will have bridging issues.

The earlier server cannot read release 15.0 backup files. You must create bcp or other scripts to move tables back to pre-release 15.0.

NoteDo not use release 15.0 schema enhancements until the conversion succeeds.

Environment

Be sure to account for any increased release 15.0 memory requirements that apply to your configuration. For more information, see:

Scheduling

For a development system, you may want to add a short period to the development schedule for release 15.0 issues.

For a production system, be prepared to postpone or fall back if needed.

Be sure to notify users when you will be taking applications or databases offline.