Data Base Tools

Utilities ››
Parent Previous Next

DATABASE TOOLS


Database Tools are accessed from the Utilities - Database Tools Menu on the SMSTurbo Tool Bar.  Click on the links below to access and edit the different features of the Database Tools Menu.  


NOTE: These tools should only be run by an SMSTurbo Administrator or SMSTurbo Support Representative.





The SQL Query Tool  provides an editor for querying the SMSTurbo SQL Server database


The Database Size button provides information on the size of the SMS database in

Microsoft SQL Express versions to review if close to database size limits.


The Backup Database button allows users to backup the SMSTurbo database


The Restore Database button allows users to restore the SMSTurbo database


The Purge Tickets button allows users to Remove Tickets from the SMSTurbo database


The Purge Other Data buttonallows users to Remove Non-ticket data from the SMSTurbo database


The Export Tickets button allows users to Export Ticket data from the SMSTurbo database


The Export Other Data button allows users to Export Non-ticket related data from the SMSTurbo database


The Customer Balance Export button allows users to export customer order balances from the SMSTurbo Database.



The Import Tickets button allows users to Import Ticket data into the SMSTurbo database


The Import Other Data button allows users to Import Non-ticket related data into the SMSTurbo database


The Customer Balance Import button allows users to import customer order

balances from a remote SMSTurbo database.



                                                     Note:  See also information on the features  Auto Export Import Tool, and the Ticket Import Tool