AppWorx, Dollar Universe and Sysload Community

Hi,

We are moving UVMS database to another server.

What is the correct way of doing this and how to fix the situation if the database in the new server doesn't work?

I was trying to find a command line command for changing the database, but couldn't find one.

So the only way to do it, is in the UVMS server database settings with Univiewer?

How to do a rollback if the changes doesn't work?

Before changes backup database and values.xml from uvms folder?

And restore the database+values.xml to restore previous settings?

Thanks in advance.

Br,

Aukusti

Assume that this is an existing UVMS with an external database? I believe that the database config is set in the values file however a new DB would be empty so the content would need to be repopulated.  (have you considered setting up UVMS in a cluster config with a corresponding mirrored DB - this is with 2 UVMS not installing UVMS onto a server cluster which is something different)

Could try updating the values file then restarting UVMS? DBAs may be able to mirror the content of the current external DB to the new DB.  

• Backup up (or make a copy of) existing Values file twice (2 copies)
• In one of the copies update the values file with the location of the new external DB and log in details
• Make a package of all definitions (security, roles, logins etc) then export as a flat file - can be used later to repopulate the DB.
• Stop UVMS
• Rename current values file to something else
• Rename the updated values file to the current values file
• Start UVMS - if all well UVMS will use the connection info in the updated values file and connect to the DB on the alternative server

If the new DB is empty you would need to re-register nodes and create new roles etc in security. You should also be able to import objects from the package created earlier

Would be best to try on a  test UVMS first