
Migrating to Sybase Adaptive Server Enterprise 11.5 3-7
Adaptive Server Enterprise 11.5 Sybase Configuration
• Web page if applicable
Applications
Make a list of applications to be migrated to Adaptive Server 11.5.
For each application, note:
• Information about data and usage
- Distributed data
- Warehoused or used in transaction processing? If used in
transaction processing, it needs to be accurate and in the right
format. Warehoused data is more tolerant of format and slight
computational differences, such as datatype conversion
differences.
• Location of application source files
• Types and number of modules containing SQL code to be
evaluated for needed modifications (triggers, stored procedures)
Sybase Configuration
Document your Sybase configuration as described in the following
sections:
• General Information 3-7
• Database Devices 3-8
• Databases and Segments 3-9
• Dump Devices 3-10
General Information
Record the following Sybase information:
• SQL Servers and their SYBASE home directories
• Components and release levels (including EBFs)
• names and location of scripts to rebuild database environment
• All SQL Server configuration values
- Save the output of
sp_configure. This shows the current settings
of all configuration parameters.
- Run buildmaster -d -yall (System 10 and below).
Kommentare zu diesen Handbüchern