Track-It! 20.xx: How to move or restore a Database to a different SQL Server - INCLUDES VIDEO

Knowledge Article

Track-It! 20.xx: How to move or restore a Database to a different SQL Server - INCLUDES VIDEO
Track-It 20.xx: How to move or restore a Database to a different SQL Server.
Track-It!
Track-It!
Track-It! 20xx and above.
Track-It!
Track-It!
Track-It! 20xx and above.
How to move or restore a Track-It 20.xx Database to a different SQL Server?

How can I migrate Track-It! database to a new server or new instance of SQL

How can I reinstall Track-It! on a new virtual server and point to existing Database

NOTE: 
In case you're looking to Restore the Database on the same SQL Server, please refer 
How to restore a Track-It 20.xx Database on the same SQL Server.

Also, in case you're not sure where the Database currently is,
How to check the Database name and SQL Server/Instance name for Track-It! 20.xx shall help.

Instructions:

1. Back up the Track-It! database using SQL Server Management Studio. Refer How to backup Track-It! 2020 database for details.
 
2. Stop the Track-It! Services on 20.xx: Application server listed below. 
  • IIS Admin services
  • TrackIt Job Processor - TrackItBR.
  • TrackIt Mail Processor - TrackItBR.
  • Track-It! infrastructure services.
  • World wide web Publishing.
 
3. Place the backup file of the database on the new SQL server.

4. Restore the backup copy into a new database on the new SQL-server with option "overwrite existing database" using SQL Server Management Studio.
 
5. (Step 4 is not necessary if no Live Track-It!  database has ever been installed on that SQL Server).
Simply perform a full restore and specify a new database name.
 
6. Delete ALL rows in the SMSYSPROCESS and NAMSYSSERVERS table by running the below SQL Query as. See How to run a SQL Query across Track-It! Database
  • "delete from SMSYSPROCESS"
  • "delete from NAMSYSSERVERS"
7. Exit SQL Server Management Studio.
 
8. On the Track-It! 20xx Application server Click Start | Select Run | Type ODBCAD32 | Press Enter.
Or Go to C:\Windows\SysWOW64 and Right-Click on the odbcad32.exe and run as Administrator.

image.png

9. Select the System DSN Tab and locate the following DSNs:
  • SelfService
  • Track-It
  • TrackItBR
image.png
 
      10. Each of those DSNs need to be reconfigured. Edit each DSN's and change the SQL Server name to point to the new SQL server. Click Next.
image.png

      11. Enter SQL SA or system admin credentials | Click Next.
image.png

      12. Tick the Change the default database to check box | Select the newly restored Track-It! database | Click Next.
image.png

      13. Click Finish.

image.png 

  14. Click Test Data Source | Click Ok 3 times to close ODBCAD32.
image.png
image.png

 15. Click Ok 3 times to close ODBCAD32.

 
NOTE: If the ODBC Test fails repeat steps 09 - 14 until the test succeeds.
 
      16. Go to Tools folder located at below path.
  • \Program Files (x86)\BMC\Track-It!\Tools and run the BMC.TrackIt.Utilities.DBLogins.exe as an Administrator.
image.png

17. Enter the password for the SA SQL Server Admin account. Either Select an ODBC, i.e. "Track-It" to the database or Tick the Use Server/Database Radio button and Enter the Database server name and Database name.
18. Provide New _SMSYSADMIN_ password and confirm it. and Click OK.
The BMC.TrackIt.Utilities.DBLogins.exe utility will report.

"SQL database accounts have been reset. The password has been changed. User account passwords have been reset to 'welcome'."
image.png
 
     19. On the application server, launch the " BMC.TrackIt.Utilities.SAUtility.exe" as Administrator from ..\Program Files (x86)BMC\Track-It\Tools\ directory.
     20. Provide the Track-It DSN, the Old Password, the New Password and confirm the Password of the _SMSYSADMIN_ account.
     21. Click on OK and wait until the tool confirms that the password has been changed and exits.
image.png
     22. Perform an IISRESET by running Command Prompt as an Administrator on the 20xx Server and Start the Track-It! Infrastructure Service manually.

     23. Log into Track-It! 20xx with the Administrator account and verify that metadata loads successfully.
 
Track-It!
Track-It!
Track-It! 20xx and above.
Attachment(s):