Delete SQL Database to start a new one
Question: I made setup errors or had import errors when I was setting up the system. How do I delete the SQL database and start over with a fresh one?
Answer: You don’t necessarily need to delete the existing database or reinstall the GigaTrak application if there is limited room on the SQL server. However, a new SQL database will need to be setup.
(If you hesitant to do this, have any issues with these steps, or need further assistance, contact our technical support group for assistance.)
To create a new clean SQL database and connect to PC application, follow these steps:
- On the server, open Microsoft SQL Server Management Studio
- Create the new database, using the instructions provided in the
‘GigaTrak_SQLSupplement(TTS,ATS,STS,or IMS)’ document provided
for each product. This document can be found on the GigaTrak Client
Center website section.
3. Run the SQL Script provided in the Order Acknowledgement email that was received when the GigaTrak software application was purchased.
If the software app has been updated since the original setup and there were database changes, you will also need to run the updated SQL Scripts provided with the update.
4. Assign either ats_user, tts_user, sts-user, or ims-user to the database (depending upon the product purchased).
5. Next, if this was a server/workstation installation, go to the shared folder created with network server install. If there was a standalone install, go to local installation folder.
6. Locate win_ats.ini, win_tts.ini, win_sts.ini, or win_ims.ini (Configuration File) in that folder.
7. Change the bolded section:
[Settings] Prodserver= This will be the server nameDbname=win_tts, win_ats, win_sts OR win_ims (new database name.. depending upon the product installed)
8. Click Save
9. Open the GigaTrak application
10. Look at the bottom right of the application screen to locate the database name. Verify the correct database has been connected to the application.