English

FAQ: Are version names case-sensitive when using ArcSDE administration commands?

Question

Are version names case-sensitive when using ArcSDE administration commands?

Answer

The version name is stored as a character string in the versions table within the database using the same case that is input within the UI or command-line interface. When the database searches for a version name, it performs a string comparison looking for an exact match. If the database is case-sensitive, using sde administration commands will require reference to the exact case of the version name to return correct results.

Oracle/DB2/PostgreSQL:
Version names are case-sensitive.

SQL Server
Version names are not case-sensitive, meaning the string 'sde.default' is equivalent to the string 'sde.DEFAULT'.

Example:
Below is an example of an ArcSDE administration command run against a database that is case-sensitive. Make note that the command using the parent version name sde.DEFAULT without using proper case does not complete successfully:

Code:
>sdeversion -o create -V editor -P sde.default -u sde -p sde -i 7171 -D sde

ArcSDE 10.0 for PostgreSQL Build 685 Fri May 14 12:05:43 2010 Version
Administration Utility
-----------------------------------------------------
Error: Version not found (-126).
Error: Unable to get parent version information.

>sdeversion -o create -V editor -P sde.DEFAULT -u sde -p sde -i 7171 -D sde

ArcSDE 10.0 for PostgreSQL Build 685 Fri May 14 12:05:43 2010
Version Administration Utility
-----------------------------------------------------
Successfully created new version sde.editor:

Related Information