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.
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
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. 9. Select the System DSN Tab and locate the following DSNs:
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. 11. Enter SQL SA or system admin credentials | Click Next. 12. Tick the Change the default database to check box | Select the newly restored Track-It! database | Click Next. 13. Click Finish. 14. Click Test Data Source | Click Ok 3 times to close ODBCAD32. 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.
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'." 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. 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. |