Changing Site IDs

Use the Change Site utility to change a name (ID value) assigned to a site.

Caution:  All users except the one running the utility must be logged out of the database when you run this utility. In a multi-site environment, this utility MUST be run for all sites and entities for each changed site value before any processing can take place in any database. For example, if you changed a site value for site A, you must run this utility at site A and also for all other sites and entities in the system.

  1. Before you run this utility, perform these steps:
    1. Make a backup of all application databases.
    2. Set the Recovery Model property for the database to Simple.
      Note:  Make a note of the current setting before you set it to Simple, so you can restore the setting later.
    3. Set the Recovery Model property for the database to Simple.
    4. Click OK.
    5. Ensure that all users except the one running the utility are logged out of the database.
    6. Ensure that no processing is performed on any database, including processing from other sites, until the utility is run at all sites that reference the site value being changed.
  2. Run the utility, specifying the old and new site names.

    If you restore an existing database as a new application database and then use this utility to change the site name, select Regenerate Replication Triggers to ensure that the new site database has unique IDs. Unique IDs are required in a multi-site environment.

    Note:  If a failure occurs while running the Change Site utility, restore the database from  backup, address any issues, and rerun the Change Site utility.
  3. Restore the Recovery Model property for the database to its original setting.
  4. If you are using Intranet Licensing, select the Intranet Licensing option again on the Sites/Entities form.