Seagate ST43401N/ND Technical Information PDF herunterladen (Seite 41)

Migrating to Sybase Adaptive Server Enterprise 11.5 3-11

Adaptive Server Enterprise 11.5 SQL Server Objects

- 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 conﬁguration and objects.

Query Sybase System Tables

The following system tables contain object information that you can

use to create installation scripts:

• sysdatabases

• sysdevices

• sysusages

• sysobjects

• sysusers

• sysservers

• syslogins

• sysremotelogins

See the System Administration Guide for more details on system tables

and objects. See also “Segment Remapping with

load database When

Moving a Database” in Technical Information Library for

information on using system tables to reconstruct databases.

Use System Stored Procedures

For information about current SQL Server conﬁguration, use

sp_conﬁgure with no argument. It will list all conﬁguration parameters

and their values.

For the SQL commands in a stored procedure, use

sp_helptext.

See the Reference Manual for other system stored procedures such as

sp_helpdevice, sp_help, sp_helpdb, sp_helpsegment and sp_helpindex that can

provide information about objects on your server.

1 2 ... 36 37 38 39 40 41 42 43 44 45 46 ... 171 172

Keine Kommentare

Seagate ST43401N/ND Technical Information Seite 41