SQL Tools

Back Office - Administration

Menu Options      ▲ ▼

Database Maintenance

• Upgrade Database
• Database Reset & Upgrade
  
  • Back Office
  • Table Tracking
• Backup Database
• Restore Database
• Reindex / Shrink Database
• Advanced Tasks
  • New Back Office Database
  • New Table Tracking Database
  • Attach Database
  • Detach Database
  • Scheduled Tasks

Database Doctor

• Check Database Tables
  • General Check
  • Back Office Database Table List
  • Table Tracking Database List
  • Check Defaults
  • Check Barcodes
    • Report Invalid/Unkown Manufacturer Barcodes
    • Export Invalid/Unkown Barcodes Report Data (CSV)
    • Delete Unused Barcodes
    • Attempt to Fix Barcodes
    • Add Barcodes From Product Codes
    • Add Padded Barcodes
  • Add Padded Metcash Supplier Codes
• Clear Transaction History
• Language Translation
• Reset Database
• Reset Totals
• Supplier Tax Rate conversion

Import & Export

• Custom Import
• Custom Export
• Export Price Book Data
• Import Opening Account Balance
• Generate Price Book

Miscellaneous Tools

• SQL Server Client Network Utility
• Back Office Memory/Statistics Settings
• Table Tracking Memory Settings
• Execute Swiftpos Script
• Performance Monitor - Reliabililty
• Performance Monitor - Resources
• Depersonalise Database
• Support File Uploader

End of article      ▲