Seagate ST43401N/ND Informações Técnicas descarregar pdf (Página 46)

4-4 Prepare: Writing a Plan and Getting Ready to Migrate

Determine Migration Approach Adaptive Server Enterprise 11.5

Fallback Plan for all users to reconnect to SQL Server 10.0.2.5 or later after you take SQL

Server 11.5 ofﬂine. Make TCP/IP address and port changes where appropriate.

Test the fallback process as part of the application test suite. This suite should

do both of the following:

• Insert data into SQL Server 11.5. The data must be replicated and available in

SQL Server 10.0.2.5 or later.

• Execute the fallback script.

Consider making daily bcp dumps of the databases. To fall back, you can then

load the dumps into release 10.x. Keep in mind:

• You may need to modify the databases to support incremental bcp dumps.

• Pre-release 11.0 cannot read release 11.5 backup ﬁles. You need to create bcp

or other scripts to move tables back to pre-release 11.x.

• Do not use release 11.x schema enhancements, such as max_rows_per_page.

For information about scheduling backups of user databases, see the System

Administration Guide.

Here are some additional tips:

• Be sure to upgrade Replication Server ﬁrst.

• Be sure the applications are using the correct server. For details on the

interfaces ﬁle and the $DSQUERY environment variable, see the

conﬁguration guide for your platform.

• Remember to include any client fallback in the calculation.

• For 7x24 sites, load time delays can impact synchronization. Consider

replicating to SQL Server 11.5 and then switching servers.

Application test suite Since the parallel with replication approach is best for high availability

applications, it is imperative that the test suite addresses both update

correctness and performance acceptability. Execute this suite before switching

users to the new system.

See Chapter 7, “Test: Ensuring Stability and Performance” for more

information on testing.

Note: 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.

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.

To ensure correct updates and acceptable performance, test the replicated

environment.

See the Replication Server Administration Guide.

Table 4-2: Parallel migration (continued)

Issue Recommendations and Tips

1 2 ... 41 42 43 44 45 46 47 48 49 50 51 ... 171 172

Sem comentários

Seagate ST43401N/ND Informações Técnicas Página 46