Migrating Servers

 1. Stand up your new Server and SSMS Server.

If you have a new application server, you can follow these instructions to set up a new install as well as a service: New Install, Set up Server as a Service. 

2. On your current production server, take a backup of the database: How to Back-Up a Database.

3. Once a backup is saved, migrate the .bak to the new Server. 

4. Make sure you copy and paste the fvserver.exe and dbupdates for the build that is the same as production.

5. To test the new database server, you can either upload a blank database to test the connection or you can take a backup of production and restore it onto the new database server.

IMPORTANT!!  If you have not shut off the old server and are testing the connection, please run the resetter to remove test credentials from this environment.

6. After testing with either a new database or the test database, you will be ready to officially migrate.

7. When you are ready to go live officially:

• Turn off the old production server and disable the services.
• Take a backup of the database.
• Restore the database onto the server.
• Start the services on the new application server.
• Comm specs will be able to log in. 
• Make sure they update the new IP address or server name if needed.