
CHAPTER 3 Analyze: Documenting Your Environment
23
Adaptive Server Objects
Document the objects in your current Adaptive Server as described in the
following sections:
• Gather Scripts to Create Objects
• If You Don’t Have Scripts
Gather Scripts to Create Objects
Locate or create the scripts necessary to recreate:
• Server level objects
• Database devices
• Configurations
• Logins and security
• Database level objects, including:
• Defaults, rules, and user datatypes
•User databases
• Users, groups, and aliases
• Tables, views, and stored procedures
• Other database objects such as triggers and indexes
You may also want need to extract and load data with
bcp. These scripts can be
used to help set up your test environment as well as the building a new
production system and may be needed if you plan to maintain two server
systems at different release levels.
If You Don’t Have Scripts
There are several ways you can reproduce scripts or access the information
needed to reproduce configuration and objects.
Commenti su questo manuale