A major step, sometimes skipped, when connected to the MCe Web/App server is to update the databases.

Running the upgrades remotely

You can do this step without connecting to the database as long as you have access to the URL MCe is on.

For example, if you server is at: https://cmms.example.com/mce then you can run the upgrade using the following additional URL pieces.

Reg Database:

• Generate SQL: /upgrades/preview/reg
• Run Upgrade: /upgrades/reg

Ent Database (don't forget to use the correct connection key if using one of the first two):

• Generate SQL: /upgrades/preview/ent/<connection key>
  • This will generate SQL that you can then run from a tool like SSMS, this is useful if the MCe user doesn't have access to that level of feature.
• Run for Database: /upgrades/ent/<connection key>
  • This is the more convenient if the MCe user has access to that level of feature
• Run for all licensed: /upgrades/ent
  • This is for running it against all your databases, test, training and prod for exmaple

Example: