- Open SQL Server Management Studio (SSMS)
- Back up your GlobalSearch production databases (default is "GetSmart") as well as your SSMaster database
- In your server's application directory (default "C:\GetSmart"), locate the file "SSMasterUpgrader.sql" and open it in SSMS.
- Execute the SSMasterUpgrader script.
- Once that completes, open the "UpgradeScript.sql" file also found in the same folder
- At the top of the query, after "USE", change the placeholder database name to the name of your production database (IE - the database you see in SSMS). This may be referenced in multiple places, depending on the version of GlobalSearch. For this reason, it is recommended that a text replacement is performed on the entire script to swap out the name (CTRL + H).
- Execute the script
- In some versions, you may see an error regarding the "ssDocusignTracking" table. This is expected. If you see any other errors, please reach out to Square 9 Support for assistance.
- This script can take some time to process and can cause a significant drop in performance in GlobalSearch while running. For this reason, it is recommended that the script is run outside of regular production hours.
- Repeat step 5 for each of your production databases, if you have more than one.
- The UpgradeScript.sql script should not be run on any of the other SQL databases (e.g. - ssProcessing, Square9Users, ssMaster or ssCapture)
|