How To: Upgrade from ArcSDE 9.x 32-bit to ArcSDE 10.x 64-bit and SQL Server 2005 32-bit to SQL Server 2008 R2 64-bit
Instructions provided describe a workflow for upgrading from ArcSDE 9.x 32-bit to ArcSDE 10.x 64-bit and SQL Server 2005 32-bit to SQL Server 2008 R2 64-bit.
- Create a BAK (backup) file of the database using SQL Server Management Studio.
- Analyze and compress the SDE database to state zero. Analyze again after compression. Refer to the following documentation for more information:
- Updating statistics on a geodatabase using the Analyze command
- The geodatabase compress operation
- The compress operation and geodatabases
- Create a BAK file of the compressed database in SQL Server Management Studio.
- Install SQL Server 2008 R2 64-bit on the new 64-bit server.
- Install SDE version 10.0 64-bit on the new 64-bit server.
- Restore the database using SQL Server Management Studio.
- Change the Compatibility Level of a Database. For more information, refer to the following page, How to: View or Change the Compatibility Level of a Database (SQL Server Management Studio).
- Create logins for the restored database and sync with database users. To do so, refer to the following article, How To: Re-synch SQL Server logins or users after restoring a database from backup.
- Upgrade the database in ArcCatalog. For more information, refer to the following document, Upgrading an ArcSDE geodatabase in SQL Server.
Note: Please note that if planning to upgrade to SP2 or SP3 later, the database must be upgraded again after installing the service pack. Also note that the ArcGIS Desktop version must have the service pack applied before upgrading the database.
- Run the post-install procedure to create services for the upgraded database. For more information, refer to the following document, Creating and starting an ArcSDE service for SQL Server.