Our DBAs need to move the Evolve database to a new server. How do we change the database Evolve is using? I am referring to the database listed under Administration> System> Infrastructure> SQL Server. If this is a change support will handle we will need to coordinate a time that works for winshuttle support and our DBAs. For now this is just a request to find out how to do this, not schedule a time to do this.
Database name will remain the same, it would only be moving to a new server.
To achieve this ; take a backup and restore the DB on new server. Then modify the connection string in the Web.config in the SVR folder then restart the Worker Services ; please see screenshot below.
Or you can simply use the modify option on the installer.
Please let me know if you have further queries on this.