MS SQL to Sybase ASE Migration Guide

Short Description
is based upon ANSI SQL 92), however the differences are minor when the …. fixed-length columns for tables in the ASE Reference Manual for further details. …

Website: www.sybase.com | Filesize: 256kb

Content
MS SQL to Sybase?ASE
Migration Guide
SYBASE, INC.
OCTOBER 2006
WHITE PAPERi
TABLE OF CONTENTS
1 1 Introduction
2 2 Migration Process
2 2.1 Application Components
2 2.2 Migrating the Data
3 2.3 Migrating the Application
3 2.4 Validate Migration
3 2.5 Optimize the Performance
4 3 Database Architecture
4 3.1 SQL Language
4 3.2 Database and Data Storage
8 3.3 Memory Management and Disk I/O
8 3.4 Database Security
10 3.5 Process Management
10 3.6 Query Processor
10 3.7 Distributed Queries
10 3.8 Distributed Transactions
11 3.9 Transaction Processing
11 3.10 Parallel Execution
12 3.11 Platform Portability
12 3.12 Backup and Restore
13 3.13 Basic Tuning
14 3.14 Other Administrator Tasks
16 4 Administrative Differences
16 4.1 Storage Management and Database Creation
16 4.2 Database Transaction Log
17 4.3 Database Server Configuration
17 4.4 Setting Database Options
17 4.5 Data Import and Export
17 4.6 Job Scheduling and Alerts
18 4.7 Space Monitoring
18 4.8 Open Transaction Monitoring
18 4.9 Auditing
19 4.10 Server Trace Flags
19 4.11 System Stored Procedures
19 4.12 Character Set Support
19 4.13 sp_tableoption Procedure
19 4.14 Start-up Procedures
19 4.15 The DBCC Command
20 Appendix A - Data Type Mapping
21 Appendix B - SQL Language Differences
36 Appendix C -…