Seagate ST43401N/ND Informacje Techniczne Pobierz pdf (Strona 142)

C-2 Sample Migration Plan Outline

Migration Approach Outline Adaptive Server Enterprise 11.5

After the successful compilation of all database objects, a Sybase-

supplied system stored procedure will be run to identify changes

due to subquery processing. Differences in SQL Server 11 can cause

unexpected result to be returned by queries.These changes will be

made manually after identiﬁcation.

Finally, some changes will neither be identiﬁed nor ﬁxed during this

phase of the migration process. These unﬁxed changes, which are not

detected by the parser, may produce run-time errors, for example if

existing programs rely on the speciﬁc wording of an error message

which has been changed. These are documented here for information

purposes only and to help diagnose future error conditions.

New System 11 features, such as new table constraints, will not be

introduced into during the migration process to minimize the

possibility of error conditions.

The following sections deﬁne phases for upgrading the Acme

Financial’s trading servers.

PHASE 1: Issues to be Addressed by PERL Program

The following issues will be identiﬁed and ﬁxed automatically by the

PERL program:

• Identify reserved words and change to agreed upon option

• Identify double hyphens (--) and change to -(-))

PHASE 2: IssUes Identiﬁed But Not Fixed by PERL Program

The following issues will be identiﬁed by the PERL program, then

ﬁxed manually:

• Identify all instances of

between in where clauses in SQL code

• Identify

set arithabort and set arithignore options

• Identify instances of:

in, any, not in

- or with exists, >all, <all, or exists,

- select distinct

- NULL results.

• Identify subqueries that use Transact-SQL functions in the

select

statement.

1 2 ... 137 138 139 140 141 142 143 144 145 146 147 ... 171 172

Brak uwag

Seagate ST43401N/ND Informacje Techniczne Strona 142