• The in-place upgrade, which replaces the original installation with the new Ingres installation. The master database (iidbdb) is upgraded with upgradedb, even though other databases are unloaded and reloaded. Because the iidbdb remains, all your locations, users, groups, and roles still exist in the new installation.

• The clean install upgrade, which leaves the original installation alone. Ingres is installed into a completely new installation. (The new installation may even be on a different machine.) When performing a clean install upgrade, you must take extra steps to recreate locations and move users, groups, and roles from the original installation to the new one.