sdesetup

including

sdesetupdb2, sdesetupinfx, sdesetupmssql, sdesetupora8i, sdesetupora9i  

This database specific command does the initial meta data setup so that the service can start and/or direct connections will work.
 

sdesetupinfx - Used for a ArcSDE Informix geodatabase
sdesetupdb2 - Used for a ArcSDE for DB2 geodatabase
sdesetupmssql - Used for a SQL Server geodatabase
sdesetupora8i - Used for a Oracle8i geodatabase
sdesetupora9i - Used for a Oracle9i geodatabase

Note: Oracle8i and Oracle9i setup programs have significant differences. It is important to run the sdesetup command built for the version of Oracle that you are using.

The usage below is abbreviated to sdesetup. The usage syntax is the same for all implementations.

Usage syntax

sdesetup -o upgrade [-H <sde_directory>] [-u <DB_Admin_user>] [-p <SDE_Admin_password>] [-D <database>]
[-s <data source>] [-l <key>] [-N] [-q]

sdesetup -o list [-H <sde_directory>] [-u <DB_Admin_user>] [-p <SDE_Admin_password>] [-D <database>]
[-s <data source>][-q]

sdesetup -o install [-H <sde_directory>] [-u <DB_Admin_user>] [-p <SDE_Admin_password>] [-D <database>]
[-s <data source>] [-l <key>] [-N] [-q]

sdesetup -o update_key -l <key> [-u <DB_Admin_user>] [-p <DB_Admin_password>] [-D <database>]
[-s <data source>][-H <sde_directory>] [-N] [-q]

sdesetup -h

sdesetup -?

Operations

Options

Discussion

The sdesetup administration utility manages the creation and maintenance of the ArcSDE geodatabase system tables, indexes, stored procedures and triggers. These database objects are owned by the ArcSDE administrator. You must supply the ArcSDE administrator password in order to create these tables.

The actual name of the command varies according to the implementation of ArcSDE as follows:

The ArcSDE system tables and stored procedures can be created or updated using the install operation. For new installs of ArcSDE the install operation will create the tables and stored procedures for the first time. For subsequent executions of the install operation on an existing database, the system table checked to ensure that it is current. If it is not, the install operation will bring it up-to-date.

The ArcSDE client applications are not upward compatible with a new versions of an ArcSDE geodatabase. Therefore before you update your ArcSDE geodatabase make sure all of your ArcSDE client programs have been updated to a compatible release. Check the install guide of your ArcSDE client application or contact ESRI technical support for compatibility information. If you are using a custom built application that was created with the ArcSDE CAPI or the ArcSDE JAVA API you must rebuild the application using the new ArcSDE client API libraries before it can connect to an updated ArcSDE geodatabase.

sdesetupora9i -o install -p fredericton

Use the update operation to bring an existing database up-to-date with the latest additions or changes to a new ArcSDE installation.

sdesetupmssql -o upgrade -p halifax

The list operation returns the current version of an ArcSDE installation.

sdesetupinfx -o list -p charlottetown

The update_key operation copies the supplied license key into the server configuration table SDE.SERVER_CONFIG. The license key allows you to use the ArcSDE software. The license string can also be included with both the install and update operations. The -l argument will accept either a file containing the license key or the license key itself. In the first example, the license key is entered directly after the -l option (note: you will need to enclose it in quotes). In the second example, the license key is contained within a text file, and the file is supplied as an argument to the -l option.

sdesetupora8i -o update_key -p quebec \
-l 'arcsdeserver,9,0002a56451f8,31-dec-2003,TRA4CAZYXMM00TEJH192'

sdesetupora8i -o update_key -p quebec -l license.dat