ArcSDE methods and considerations for migrating DBMS to 64-bit Windows on 32-bit Windows systems

Source: Internet
Author: User

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

If you is running ArcSDE as a 32-bit application connecting to an existing 32-bit the 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 comp Onent of ArcGIS Server Enterprise.

  6. Make sure there is no users currently making a direct connection to the geodatabase.
  7. Grant upgrade permissions to the ArcSDE administrator user. See the 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 Remot e one). Proceed with the Post Installation Wizard.
  9. Decide How do 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 has each user transfer His/her own data so it is owned by, same user in the new geodatabase.

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

ArcSDE methods and considerations for migrating DBMS to 64-bit Windows on 32-bit Windows systems

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.