The files that allow you to use ArcSDE geodatabases on ArcSDE database servers are part of ArcGIS clients. Therefore, geodatabases on ArcSDE database servers (instances of SQL Server Express) may need upgrading after you install a newer version of ArcGIS Desktop or ArcGIS Engine software.
If you have the Advanced or Standard edition of ArcGIS Server Workgroup and you upgrade that product, you will likely also need to upgrade ArcGIS Desktop and your geodatabases, because you cannot have two different versions of an ArcGIS product on the same machine.
There can be two parts to this upgrade: upgrading the SQL Server Express database management system (DBMS) and upgrading the geodatabase.
Beginning with ArcGIS 9.3, SQL Server Express with Advanced Services is used to store ArcSDE geodatabases on ArcSDE database servers. This provides additional support for full-text searches, which allow you to create ArcIMS Metadata Services using ArcSDE geodatabases licensed through ArcGIS Server Workgroup as data sources.
If you were using ArcSDE database servers with ArcGIS 9.2, you can upgrade your SQL Server Express instance when you install ArcGIS 9.3 or later releases.
- Before running the installation executable file, be sure to make a backup of all your geodatabases.
- When you run the ArcSDESqlExpressPersonal.exe or ArcSDESqlExpressWorkGroup.exe file, keep the Microsoft SQL Server 2005 Express Edition option checked on the ArcSDE Installation Options dialog box.
- When the Instance Name dialog box of the SQL Server Express with Advanced Services installation appears, choose the instance you want to upgrade. Read the ArcSDE geodatabase installation guide that comes with ArcGIS Desktop, ArcGIS Server Workgroup, or ArcGIS Engine for complete instructions.
Unless you received a new ArcGIS Server Workgroup license key, you do not need to complete the ArcSDE postinstallation portion of the installation.
How you upgrade a geodatabase depends on whether or not the client from which you perform the upgrade has ArcGIS pre-9.3 geodatabase direct connect drivers installed or not. The following steps assume you have the 9.2 direct connect drivers installed.
The upgrade procedure for clients that do not have these drivers is explained at the end of this topic.
After installing a new release of ArcGIS Desktop or ArcGIS Engine, a user who is a database server administrator (dbo) in the SQL Server Express instance should do the following:
- Start ArcCatalog.
- Connect to the database server.
- Right-click the first geodatabase on the database server and click Properties.
- Click the General tab. If an upgrade is needed, the Upgrade Geodatabase button will be active. Click the button to upgrade the geodatabase.
If you do not want to upgrade the geodatabase, you will still be able to connect to the data, but you won't be able to use newer geodatabase functionality available with the new ArcGIS release you installed.
- Repeat steps 3 and 4 for each geodatabase on the database server you want to upgrade.
- When you are finished upgrading all the geodatabases you want to, right-click the database server and click Disconnect. To continue working with the database server and its geodatabases, either double-click the database server or right-click it and click Connect to reconnect to it.
It is also possible for non-dbo users to upgrade the geodatabases for which they have been granted geodatabase administrator permissions. For example, perhaps at your site you have one geodatabase administrator for each geodatabase. In that case, each geodatabase administrator should connect to the database server in ArcCatalog and upgrade the geodatabase for which he or she is responsible, then disconnect and reconnect to the database server.
See
Administering user permissions for ArcSDE database servers for information on geodatabase administrators.
If you are connecting as either dbo or the geodatabase administrator but cannot connect to the geodatabase—for instance, if you are missing the drivers necessary to connect to an older geodatabase—you will automatically be prompted to upgrade the geodatabase. When the upgrade dialog box appears, click Yes to upgrade. After the upgrade, you should be able to connect to the geodatabase.
