--- title: "Step 10: Moving a Database to a New Server (optional)" slug: "moving-a-database-to-a-new-server" updated: 2025-03-07T11:08:15Z published: 2025-03-07T11:08:15Z canonical: "docs.avontus.com/moving-a-database-to-a-new-server" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.avontus.com/llms.txt > Use this file to discover all available pages before exploring further. # Step 10: Moving a Database to a New Server (optional) The following instructions detail how to move your Quantify database to a new server. > [!CAUTION] > **Important:** You should only move a database when replacing or changing the hosting server. Always contact [Avontus Support](mailto:support@avontus.com) before changing server or other database hosting information. ## Install SQL Server on the New Server These steps can be completed without requiring users to log out of the database. To install SQL Server on the new server: 1. Install SQL Server on the new server. This should be the same version of SQL server (or greater) that is installed on your current server. For our basic step by step instructions for this step, refer to [*step 2: Install SQL Server 2017 Express*](/v1/docs/step-2-install-sql-server-2017-express). 2. [Install Quantify](/v1/docs/installing-quantify) and [Quantify's Database Tools](/v1/docs/step-5-install-database-tools) on the new server. > **Note:** This is not a requirement For complete instructions for this step, refer to [*Installing Quantify*](/v1/docs/installing-quantify). It is recommended that you update your current installation of Quantify to the most current version before completing the next steps. To see if you have the most current version installed, login to Quantify, click the **Help** menu and select **About**. 3. Launch Quantify Database Tools and create a new database as detailed in [*Step 6: Create a Blank Database*](/v1/docs/step-6-create-a-blank-database). This sets the appropriate permissions for the restore of the actual database. 4. In Quantify Database Tools, click **Delete** and delete the database that was created in the previous step. You are now ready to restore. ## Using Quantify's Database (DB) Tools to Back Up a Database Quantify's Database Tools makes creating database backups simple and easy. You can use this utility on any machine that hosts SQL Server and the Quantify database. These steps require users to log out of Quantify to ensure data is not entered in the database after a backup is created for the migration. For assistance with these steps, refer to the Microsoft help files for your version of SQL Server, such as [http://technet.microsoft.com/en-us/library/586561fc-dfbb-4842-84f8-204a9100a534](http://technet.microsoft.com/en-us/library/586561fc-dfbb-4842-84f8-204a9100a534) To back up a database: 1. Click the **Start** menu, then locate and select **Database Tools for SQL** from the **Quantify** sub-menu. The *Quantify Database Tools* dialog appears. 2. Click **Backup**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-8UGTXG5Z.png) The *Backup Database* dialog appears. 3. Click **Browse**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-W4UI948L.png) The *Backup to File* dialog appears. 4. Navigate to the directory into which you want to save the backup file and click **Save**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-5CX70OQH.png) The *Backup Database* dialog returns. 5. Click **OK**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-VXCNH1ZC.png) When the backup is complete, a confirmation dialog appears. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/5fb088dd-e5e8-4553-81d4-9c4d87f58afb.png) 6. Click **OK**. The *Quantify Database Tools* dialog returns. 7. Click **Close**. To send a database to Avontus support see [*Sending a Database to Avontus Support*](/v1/docs/sending-a-database-to-avontus-support). ## Restoring the Existing Database To restore the existing database: 1. Click Restore ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/543271ff-4f33-4081-bcac-5e9cc523e470.png) The *Restore Database* dialog appears. 2. Click Browse The *Restore from File* dialog appears. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/89dc672f-0a17-413b-803b-6bda9b9b7c1e.png) 3. Navigate to the directory in which the appropriate database file resides and click **Save**. The *Restore Database* dialog returns. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/39431c88-a58b-4948-8c1a-0e3613a999bc.png) 4. Click **OK**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/695bd3f4-1c8a-4176-94f8-650758020ec0.png) When the restoration is complete, a confirmation dialog appears. 5. Click **OK**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/da73ca14-4276-443c-b718-700a0c903ee8.png) The database is now ready for use. You can find these steps in detail here: [*Using Quantify's Database (DB) Tools*](/v1/docs/using-quantifys-database-db-tools). When you first use Quantify to open the migrated database, it will prompt you to activate the database. 6. [Email this activation request](/v1/docs/step-8-request-an-activation-code) to [support@avontus.com](mailto:support@avontus.com). The activation request will receive a prompt response. After the migration is complete, the Quantify clients must be redirected to login to the new server location. 7. [To do this](/v1/docs/using-quantify-to-log-in-to-a-remote-quantify-database): 8. Log in with the same credentials as before. 9. To prevent segmentation of data, it is highly recommended that you disable user access to the current servers/databases once the migration is complete. You can retain the backups and remove the active databases from these instances once the new connections are established. 1. Launch Quantify on the client. The *Quantify Login* dialog appears. 2. Click the **Connect to a Database or Remote Server** button ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/d881ca2f-2e0a-4914-9569-f4fd2f6c51b9.png)). The *Connection Settings* dialog appears. 3. Click the **Remote Server** radio button. 4. Click in the **Server Address** text field and enter the address of the Quantify database. 5. As necessary, click the **Connect Using SSL** checkbox, to put a check in it. 6. Click **OK**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-K8ZAIFL5.png) The *Quantify Login* dialog returns. You can find these steps in detail here: [Using Quantify to Log In to a Remote Quantify Database](/v1/docs/using-quantify-to-log-in-to-a-remote-quantify-database).