Back Office > Administration > SQL Tools > Database Maintenance > Advanced Tasks > New Table Tracking Database
Description
This menu item is used to create a blank new SwiftPOS Table Tracking Database.
The SwiftPOS Table Tracking Database is created in the folder specified with the Database name provided. The created Database is also attached to the SQL Server.
To Be Considered
- Note : Do not connect to a Table Tracking Database over the internet.
|
The reason for this is Floor Layouts are refreshed every 10 seconds to update the status of tables. This would seriously impact the traffic over the internet. Another reason is, held sales are also saved to the Table Tracking Database. It is recommended that the Table Tracking Database should always be local to the site. |
- The Table Tracking Database can be installed on a PC/Server or on a SwiftPOS Touch terminal. Hence, it can be created locally and then transferred, by backing it up and restoring it to another PC/Server or SwiftPOS Touch terminal.
- Note - When creating a new Table Tracking database, you must also perform a Reset and Upgrade on this new Database.
New Table Tracking Database
- Database Name - Leave the name unchanged to recreate/blank the currently connected Database. If creating a new SwiftPOS Table Tracking Database for the first time enter 'TABLETRACKING' as the recommended name for the Database. If creating an alternate Database then the name entered must be alphabetic characters (A-Z) only with no embedded spaces. For example 'TABLETRACKINGTEST'. Note : For a first time created SwiftPOS Table Tracking Database or for an alternate Database, SQL Server Connections will have to be created. This can be done here.
- Destination Path - Enter 'C:\SWIFTPOS' (recommended). Select the Change button to select an alternate location.
- Create - Select to create the blank Database. The following pop up will be displayed when recreating an existing Database:
|
Select Yes to overwrite. |
- Close - Select to exit.
Once created the Database will be automatically attached to the SQL Server. Also two files are created for every Database created:
- xxxx.MDF file - is the actual SQL Database file. Example : C:\SwiftPOS\TABLETRACKING.MDF
- xxxx.LDF - is the SQL Database log file. Example : C:\SwiftPOS\TABLETRACKING.LDF. Note : A SQL Database cannot be attached without it's log file. Attempting to do this with a different Log file will result in an error.
Note : If for some reason SwiftPOS utilities stopped responding during the Database upgrade you can run the Reset Database version and Upgrade option which should clear up any upgrade issues that may have occurred.
Related Topics
