Create a Blank Database

OVERVIEW

It may make sense to create a blank database before begining your database setup and programming to ensure the cleanest format and data. This article describes how to create a generic blank database on a Venue Server.

PREREQUISITES

N/A

PROCEDURE

Create Database

1. Run Database.exe on the Venue Server
2. Enter Access Code to run the program
3. Go to the Modify Databases Tab and click Create New Database
4. Enter a database name and click OK
5. Pick the local Bepoz Data directory (usually C:BepozData) and Save
6. Enter the desired database size and click OK
7. Database.exe creates the database
8. Click Yes to make the new database accessible with BackOffice.exe

Database Sizing Rule of Thumb:

1000 MB – Small store or low volume transactions
3000 MB – Medium size business or moderate transactions
9500 MB – Large Enterprise, high volume transactions, limit for SQL 2008R2 Express
10000 MB and Greater – Requires paid version of SQL Server and data storage considerations by business IT department based on historical usage trends

Initialize Database

1. Run BackOffice.exe
2. Set Organization Name to be the name of the Business and click OK (other settings will be revisited)
3. Set Venue Name to be the name of the Business Physical Location (Location Store #, Street Name, etc) and click OK
4. Set the Store Name to be the first store in the database (see Glossary for explanation of Bepoz Stores) and click OK
5. Set the Till/Workstation Name and click OK

Database Configuration Highlights

Specialized settings are covered in other topics. The instructions below highlight the procedure to access Global, Venue, Store, & Till/Workstation specialized settings, and provide screenshots of the various settings included in each section for reference.

1. Login to BackOffice.exe
2. Go to System Setup on the left column and click Venue, Stores, and Tills
3. Double Click Global Settings to access the setup screen
4. Global Main Tab Settings
5. Global Sorts & Types Tab Settings
6. Global Other Names Tab Settings
7. Clicking Cancel will return to the Venue, Stores, and Tills Screen
8. Double Click the Venue to access the Venue setup screen
9. Venue Main Tab
10. Venue Names Tab
11. Venue External Links Tab
12. Venue Tables Tab

RESOURCES

N/A1