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 Server2013 06 22 000156 - Create a Blank Database
  2. Enter Access Code to run the program
  3. Go to the Modify Databases Tab and click Create New Database 2013 06 22 000157 - Create a Blank Database2013 06 22 000158 - Create a Blank Database
  4. Enter a database name and click OK
  5. Pick the local Bepoz Data directory (usually C:BepozData) and Save 2013 06 22 000159 - Create a Blank Database2013 06 22 000160 - Create a Blank Database
  6. Enter the desired database size and click OK
  7. Database.exe creates the database 2013 06 22 000161 - Create a Blank Database
  8. Click Yes to make the new database accessible with BackOffice.exe2013 06 22 000162 - Create a Blank Database

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) 2013 06 22 000163 - Create a Blank Database
  3. Set Venue Name to be the name of the Business Physical Location (Location Store #, Street Name, etc) and click OK 2013 06 22 000164 - Create a Blank Database
  4. Set the Store Name to be the first store in the database (see Glossary for explanation of Bepoz Stores) and click OK 2013 06 22 000165 - Create a Blank Database
  5. Set the Till/Workstation Name and click OK 2013 06 22 000166 - Create a Blank Database

 

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 2013 06 22 000170 - Create a Blank Database
  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 2013 06 22 000173 - Create a Blank Database
  4. Global Main Tab Settings 2013 06 22 000174 - Create a Blank Database
  5. Global Sorts & Types Tab Settings 2013 06 22 000175 - Create a Blank Database
  6. Global Other Names Tab Settings 2013 06 22 000176 - Create a Blank Database
  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 2013 06 22 000177 - Create a Blank Database
  10. Venue Names Tab 2013 06 22 000178 - Create a Blank Database
  11. Venue External Links Tab 2013 06 22 000179 - Create a Blank Database
  12. Venue Tables Tab 2013 06 22 000180 - Create a Blank Database

 

RESOURCES

N/A1

Leave a Comment