

Follow these steps to upgrade your primary SQL Server. Before doing so, ensure you have completed the required pre-upgrade steps.
Note: This page also contains steps for upgrading a distributed SQL Server. You must upgrade your primary SQL Server before proceeding with these upgrades.
The master database, called the EDDS database, resides on the primary SQL Server. You must upgrade Secret Store before updating the primary database. For more information, see Upgrading the Secret Store.
You can then run the web and agent server installations in parallel.
Save the following files to the root directory of any server contributing to the Relativity environment:
start /wait "" "INSERT EXACT NAME OF RELATIVITY INSTALLATION FILE" /log InstallLog.txt /responsefilepath=RelativityResponse.txt
Note: Every line in the RelativityResponse.txt file that starts with ### is a comment and meant to provide instruction.
Open the RelativityResponse.txt file in a text editor and edit the parameters as follows to upgrade Relativity on the machine that serves the role of the primary SQL Server:
Note: If you are upgrading to Server 2024, some values in your response file may now be stored in the Secret Store. These values are identified by the following message: "Value exported to Secret Store." You don't need to edit these values unless you want to update the Secret Store. For more information, see Secret Store.
INSTALLPRIMARYDATABASE=1
INSTALLDISTRIBUTEDDATABASE=0
INSTALLDIR=C:\Program Files\kCura Corporation\Relativity
PRIMARYSQLINSTANCE=ML12
EDDSDBOPASSWORD=MySecretPassword
SERVICEUSERNAME=example\exampleusername
SERVICEPASSWORD=MySecretPassword
USEWINAUTH=1
Note: If the USEWINAUTH value is set to one, then the user running the installer must be a SQL sysadmin, and any values entered for SQLUSERNAME and SQLPASSWORD are ignored.
SQLUSERNAME=mySqlUserName
Note: This value is ignored if USEWINAUTH is set to one.
SQLPASSWORD=myPassword
Note: This value is ignored if USEWINAUTH is set to one.
DEFAULTFILEREPOSITORY=\\yourmachine\FileShare
EDDSFILESHARE=\\yourmachine\Fileshare
CACHELOCATION=\\yourmachine\ViewerCache
DTSEARCHINDEXPATH=\\yourmachine\dtSearch
RELATIVITYINSTANCENAME=My Relativity Instance
ADMIN_EMAIL=relativity.admin@relativity.com
SERVICEACCOUNT_EMAIL=serviceaccount@relativity.com
ADMIN_PASSWORD=myPassword
SERVICEACCOUNT_PASSWORD=myPassword
Note: To change the ADMIN_PASSWORD or SERVICEACCOUNT_PASSWORD password, you must also update the associated email address. If you enter a new password but do not update the email address, then new password is ignored. For example, if you use an existing or default email address, then the password remains unchanged. However, you can change the email addresses for the admin and service accounts without updating the password.
We recommend that the following database paths are local to the SQL Server and accessible. However, we also support UNC paths on SQL Server 2017 and above.
DATABASEBACKUPDIR=C:\Backup
LDFDIR=C:\Logs
MDFDIR=C:\Data
FULLTEXTDIR=C:\FullText
Save your edits to the RelativityResponse.txt file, and launch the Install.bat file to proceed with the upgrade.
A sample RelativityResponse.txt file for a primary SQL database upgrade using Windows authentication looks like this:
INSTALLPRIMARYDATABASE=1 INSTALLDIR=C:\Program Files\kCura Corporation\Relativity PRIMARYSQLINSTANCE=ML12 EDDSDBOPASSWORD=MySecretPassword SERVICEUSERNAME=example\exampleusername SERVICEPASSWORD=MySecretPassword DEFAULTFILEREPOSITORY=\\yourmachine\FileShare EDDSFILESHARE=\\yourmachine\Fileshare CACHELOCATION=\\yourmachine\ViewerCache DTSEARCHINDEXPATH=\\yourmachine\dtSearch RELATIVITYINSTANCENAME=My Relativity Instance ADMIN_EMAIL=relativity.admin@relativity.com SERVICEACCOUNT_EMAIL=serviceaccount@relativity.com ADMIN_PASSWORD=myPassword SERVICEACCOUNT_PASSWORD=myPassword DATABASEBACKUPDIR=C:\Backup LDFDIR=C:\Logs MDFDIR=C:\Data FULLTEXTDIR=C:\FullText USEWINAUTH=1
Note: Every line in the RelativityResponse.txt file that starts with ### is a comment and meant to provide instruction.
If your Relativity environment uses a distributed SQL Server, then you need to run the installer on a machine other than the one that hosts the primary SQL database. After you have upgraded the primary SQL Server, you can upgrade the distributed database server and the web and agent server upgrades in parallel.
Open the RelativityResponse.txt file in a text editor and edit the parameters as follows to upgrade Relativity on the machine that serves the role of the distributed SQL Server:
INSTALLPRIMARYDATABASE=0
INSTALLDISTRIBUTEDDATABASE=1
INSTALLDIR=C:\Program Files\kCura Corporation\Relativity
PRIMARYSQLINSTANCE=ML12
EDDSDBOPASSWORD=MySecretPassword
SERVICEUSERNAME=example\exampleusername
SERVICEPASSWORD=MySecretPassword
USEWINAUTH=1
Note: If the USEWINAUTH value is set to one, then the user running the installer must be a SQL sysadmin, and any values entered for SQLUSERNAME and SQLPASSWORD are ignored.
SQLUSERNAME=mySqlUserName
Note: This value is ignored if USEWINAUTH is set to one.
SQLPASSWORD=myPassword
Note: This value is ignored if USEWINAUTH is set to one.
DISTRIBUTEDSQLINSTANCE=ML14
We recommend that the following database paths are local to the SQL Server and accessible. However, we also support UNC paths on SQL Server 2017 and above.
DATABASEBACKUPDIR=C:\Backup
LDFDIR=C:\Logs
MDFDIR=C:\Data
FULLTEXTDIR=C:\FullText
Save your edits to the RelativityResponse.txt file, and launch the Install.bat file to proceed with the upgrade.
A sample response file for a distributed SQL database upgrade using Windows authentication looks like this:
INSTALLDISTRIBUTEDDATABASE=1 INSTALLDIR=C:\Program Files\kCura Corporation\Relativity PRIMARYSQLINSTANCE=ML12 EDDSDBOPASSWORD=MySecretPassword SERVICEUSERNAME=example\exampleusername SERVICEPASSWORD=MySecretPassword DISTRIBUTEDSQLINSTANCE=ML14 DATABASEBACKUPDIR=C:\Backup LDFDIR=C:\Logs MDFDIR=C:\Data FULLTEXTDIR=C:\FullText USEWINAUTH=1
Note: Every line in the RelativityResponse.txt file that starts with ### is a comment and meant to provide instruction.
Why was this not helpful?
Check one that applies.
Thank you for your feedback.
Want to tell us more?
Great!