32位Windows 系统上 迁移DBMS到64 位Windows 的ArcSDE 方法及注意事项

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.

  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 SQL Server.
  8. 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.
  9. 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.
  10. After testing to be sure everything is working properly in the new geodatabase, uninstall the ArcSDE component from the 32-bit server.

32位Windows 系统上 迁移DBMS到64 位Windows 的ArcSDE 方法及注意事项

上一篇:mysql02


下一篇:Teach Yourself SQL in 10 Minutes – Page 31 练习