Document the objects in your current Adaptive Server.
Locate or create the scripts necessary to re-create:
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 to extract and load data with bcp. You can use these scripts to set up your test environment and build a new production system. They may be needed if you plan to maintain two server systems at different release levels.
If you do not have scripts, there are several ways you can reproduce scripts or access the information needed to reproduce configuration and objects:
Query system table – The following system tables contain object information that you can use to create installation scripts:
sysdatabases
sysdevices
syslogins
syspartitions
sysobjects
sysremotelogins
sysservers
sysusages
sysusers
See the System Administration Guide for information on system tables and objects and “Segment Remapping with load database When Moving a Database” at http://www.sybase.com/detail?id=1324 for information on using system tables to reconstruct databases.
Use system stored procedures – For information about current Adaptive Server configuration, use sp_configure with no argument. It lists all configuration parameters and their values.
Use sp_helptext for the SQL commands in a stored procedure.
See the Reference Manual: Procedures for information about other system stored procedures such as sp_helpdevice, sp_help, sp_helpdb, sp_helpsegment, sp_helpartiton, and sp_helpindex that provide information about objects on your server.
Use Sybase tools – You can reverse-engineer server objects using Sybase tools such as Sybase Central™, PowerDesigner™ and WorkSpace, or other third-party tools
