Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 32 bit

If you have an existing 32-bit ArcSDE installation, you cannot directly upgrade to a 64-bit installation.

If you are running ArcSDE as a 32-bit application connecting to an existing 32-bit database management system (DBMS), but you want to move to a 64-bit ArcSDE installation and a 64-bit DBMS, follow the instructions in this topic.

Steps:

Upgrade your existing geodatabase if necessary; for example, if you are upgrading from ArcSDE 9.3 to 10.0 and then migrating to a 64-bit database, first upgrade your existing geodatabase.
1. Reconcile all geodatabase versions with the default version.
2. Delete the other geodatabase versions.
3. Compress the geodatabase.
4. Create a backup of the database.
5. Stop the ArcSDE service, if one is running.

   sdemon -o shutdown -i <service> -s <server_name> -p <ArcSDE_administrator_password>

   For details on using the sdemon command, consult the ArcSDE Administration Command Reference provided with the ArcSDE component of ArcGIS Server Enterprise.

6. Make sure there are no users currently making a direct connection to the geodatabase.
7. Grant upgrade permissions to the ArcSDE administrator user. See User permissions to create or upgrade a geodatabase in Oracle.
8. Upgrade your existing geodatabse.
Set up the new server and database.
9. Install your 64-bit DBMS software on your 64-bit server.
10. Install the 64-bit version of the ArcSDE component on a 64-bit server (either the one on which the DBMS resides or a remote one). Do not proceed with the Post Installation wizard.
11. Update the st_shapelib.dll library definition in the Oracle data dictionary.

    CREATE or REPLACE LIBRARY <library_name> AS
    '<path_to_library>'

Move your data to the new DBMS.
12. Decide how you want to transfer your data. You can do one of the following:
    • If your DBMS offers functionality to move the entire database, you can use the DBMS tools to do so. Move the entire database from the 32-bit instance to the 64-bit instance using DBMS tools.
    • Set up a second geodatabase on the 64-bit instance and use XML workspace documents or copy and paste in ArcGIS, or ArcSDE export files to move the data from the old geodatabase to the new one.

    If you decide to move the entire database, see your DBMS documentation for instructions. If you decide to set up a second geodatabase and move the data, do the following:

    1. Perform the postinstallation setup using the Post Installation wizard to create a new geodatabase on the 64-bit instance.
    2. Move the data from the 32-bit geodatabase to the 64-bit geodatabase using XML workspace documents, copy and paste, or ArcSDE export files.
       Note:

       You should have each user transfer his/her own data so it will be owned by that same user in the new geodatabase.

    3. After moving the data, rebuild indexes and update database statistics.
13. After testing to be sure everything is working properly in the new geodatabase, uninstall the ArcSDE component from the 32-bit server.