Seagate ST43401N/ND Technical Information Seite 7
- Seite / 172
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Migrating to Sybase Adaptive Server Enterprise 11.5 vii
Adaptive Server Enterprise 11.5
Datatype Hierarchy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-5
Datatype Conversions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6
ANSI SQL92 Support for Conversion Error Handling. . . . . . . . . . . . 5-7
Subquery Processing Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8
in and any. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8
not in. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9
or...exists/in/any . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-10
>all and <all . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-10
Correlated Subqueries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-11
Aggregates with exists. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-12
select distinct. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-13
Additional ANSI-Related Transact-SQL Changes. . . . . . . . . . . . . . . . . . 5-13
between . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-13
ANSI Comments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-14
Correlation Names. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-14
select into and NULL Column Headings. . . . . . . . . . . . . . . . . . . . . . . 5-15
If Your Current Version is 4.x or 10.x . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-16
New Reserved Words in Version 11.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-16
Subquery Processing Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-17
Expression Subqueries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-17
No set dup in subquery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-17
union Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-18
Subqueries and NULL Results. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-18
No Subqueries in Updatable Cursors . . . . . . . . . . . . . . . . . . . . . . . . . 5-18
If Your Current Version is 4.x, 10.x, or 11.0.x . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-19
New Reserved Words in Version 11.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-19
Reserved Words in 11.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-19
Changing Reserved Words in Your Applications . . . . . . . . . . . . . . . 5-20
Avoiding Future Reserved Word Conflicts. . . . . . . . . . . . . . . . . . . . . 5-20
Using the set Command to Keep Object Names . . . . . . . . . . . . . . . . 5-20
Sorted Order in Queries with Clustered Indexes. . . . . . . . . . . . . . . . . . . 5-21
Changes Due to Two-Phase Commit Enhancements . . . . . . . . . . . . . . . 5-21
A Few Transact-SQL Programming Tips. . . . . . . . . . . . . . . . . . . . . . . . . . 5-21
Syntax That Can Slow You Down . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-21
General Tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-24
Learn More About Coding For Performance. . . . . . . . . . . . . . . . . . . 5-25
6. Implement: Making Required Database Administration Changes
In this Chapter. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1
If Your Current Version is 4.x. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1
New Reserved Words in Version 10.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-2
- Migrating to Sybase® 1
- Table of Contents 5
- A. The Cyrano Migration Pack 9
- E. Migration Plan Checklist 12
- List of Tables 13
- Introduction and Guide to 15
- Resources 1 15
- Chapter Title Contents 16
- Technical Information Library 18
- Migration Web Page 19
- Migration Courses 19
- Sybase Press Books 20
- Third-Party Books 20
- Consulting Services 20
- Third-Party Tools 21
- If You Need Help 21
- Analyze: Documenting Business 23
- Requirements 2 23
- Acme Brokerage Company 24
- System Architecture 24
- Availability Requirements 25
- Database Change Metrics 25
- Maintenance Procedures 26
- Service Level Requirements 27
- Current Performance Metrics 28
- • Vendor issues 30
- Analyze: Documenting Your 31
- Environment 3 31
- CPU Resources per Machine 32
- Disk Configuration 32
- Network Configuration 34
- Tape Configuration 34
- Physical Memory Utilization 35
- Software Configuration 36
- Sybase Configuration 37
- SQL Server Objects 40
- If You Don’t Have Scripts 41
- Ready to Migrate 4 43
- Parallel With Replication 45
- Cutover Without Replication 47
- Phased Cutover 49
- Write a Migration Plan 50
- Update Hardware Resources 51
- Create Migration Scripts 52
- Implement: Making Required 55
- Application Changes 5 55
- Datatype Changes 57
- Table 5-3: Datatype hierarchy 59
- Name Hierarchy 59
- Subquery Processing Changes 62
- NULL Algodata Infosystems 64
- NULL New Age Books 67
- Binnet & Hardley 67
- Algodata Infosystems 67
- 250 no rows returned 68
- Enterprise 11.5 73
- Login and Password Changes 82
- RUN File Renamed 83
- New create table Permission 84
- New Backup Server 85
- Last Chance Threshold 85
- Reference Supplement 86
- Configuration Interface 88
- Old Name New Name 89
- Databases Online / Offline 90
- Increased Memory Requirements 92
- Figure 6-1: Areas of memory 93
- 4.x 125% 96
- 10.x 50% 96
- 11.0.x 25% 96
- Optional Space Considerations 98
- Test: Ensuring Stability and 101
- Performance 7 101
- Make Backups 102
- Summary of Testing Techniques 104
- • Production load capture 105
- Writing Performance Scripts 106
- Test Cycle: Summary of Tests 109
- Stage Purpose Best Technique 110
- Pre-Upgrade Single-User Tests 111
- Pre-Upgrade Multi-User Tests 111
- Test System Upgrade 112
- Post-Upgrade Multi-User Tests 113
- The Cyrano Migration Pack A 115
- For More Information 117
- A-4 The Cyrano Migration Pack 118
- Worksheets for Your Current 119
- Environment B 119
- Backup and Restore Procedures 121
- Database Dump Details 122
- Data Architecture Worksheet 124
- Transaction Profile 126
- Host Configuration 127
- Record CPU resources: 128
- Physical Memory Usage 129
- Operating System Configuration 134
- Detail the operating system 134
- SQL Server Configuration 135
- Table B-18: dbcc output 136
- Usage MB 2K Pages Bytes 136
- Database Devices 137
- Databases and Segments 138
- Dump Devices 139
- Migration Approach Outline 141
- In This Appendix 145
- Sample Task List Template 145
- Migration Analysis 146
- Migration Preparation 147
- Migration Quality Assurance 151
- Set Up Replication Server 154
- Run Regression Test Suites 154
- Perform Final Steps 156
- Staged Cutover Task Overview 161
- Migration Plan Checklist E 163
- Logical Support Architecture 165
- Migration Strategy Design 165
- E-4 Migration Plan Checklist 166
© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.104 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern