How to manually run the database schema update script in Act!

Question:  How do I manually run the database schema update script?
 
Product Details: 
Product Family:  Act!
Product:  Act! Pro, Act! Premium
Version: v18.1 and later
 
 

---

Answer: 
 
Important Notes:

• These steps should only be run if you were instructed to do so by an article that linked to these steps, or by an Act! support analyst
• These steps must be performed from the machine which is acting as the database server
• Before proceeding with the steps below, it is recommended that you create a backup of your database. For information regarding creating a database backup refer to the following knowledgebase article:
  
  How to back up and restore an Act! database
  Answer ID How to back up and restore an Act! database
   
   

You can run the update script by following the steps below:

1. Ensure Act! is closed
2. Browse to the Act! Program installation directory
   
   Note: For information on default locations for the Act! program installation directory, refer to the following knowledgebase article:
    
   What are the default locations for key files in Act!?
   Answer ID What are the default locations for key files in Act!?
    
3. Locate ActUpdate.config and open it with Notepad
4. Once the file has opened, click File > Save As
5. Enter the name as ActUpdate.old, then click Save
   
   Note: By default this will save in the same location as ActUpdate.old.txt
   
   
6. Close the open copy of the file, then locate ActUpdate.config and open it with Notepad again
7. Locate the line that starts with <LatestSchemaVersion> and make a note of the number shown on that line
8. Change the number that falls after the first decimal point to a 9. For example, if it reads 18.2.52.0, change it to 18.9.52.0
9. Save and close the file
10. Log in to your database as an Administrator user
11. When prompted to take a backup of the database before updating, click No
12. When prompted to update the database, click OK, or if in v20 or later, click Yes
13. When the confirmation that the update completed appears, click OK
14. When receiving subsequent prompts from steps 12 and 13, click No and Cancel until no more prompts appear
    
    Note: You may receive the Log on window after dismissing the subsequent prompts. If the Log on window, click Cancel on this as well.
     
15. Close Act!
16. Edit the ActUpdate.config to revert the number back to the number you noted in step 7, then save and close the file