Rodlan Products

(435) 752-8503

SQL Database Server

Why a Database Server?
An SQL database server is a computer program that resides on a computer on your network that allows computers in different locations to connect to the School Lunch data file. This allows users in different locations to access the same information. The best scenario is to have the server on a computer that will be left on most all of the time.

The Rodlan School Lunch program uses a SQL database server that allows multiple computers to connect to the same School Lunch database via the multi-user program or the multi-school program.
New in 2011 the Studio Stable Database Server is included in the price of either network installation eliminating the need for additional purchase.

School Lunch Multli-User System
The multi-user program allows many computers to connect in a single school. Office personal and lunchroom staff can work on the system at the same time, answering parent's questions, making deposits, or processing kids through the lunch line all at the same time. Multiple lines may run at the lunchroom at the same time making student processing go much faster. Computers are connected via a local area network in the school.

School Lunch Multli-School System
The multi-school system works just like the multli-user system but is designed for small districts that wish to connect up to six schools to the same database. This works great for schools that wish to take advantage of the School Lunch family account. All family money may be deposited in a single family account and used by students in any school on the system that belong to the family account. Reports can be printed in the schools or on a district level.

Advantages of the SQLServer Database Server
► An SQL database server can easily perform daily backups.
► Unlimited connections to the School Lunch data file can happen concurrently..

Things to Consider
► Server computer requires a static IP address for consistent client connections.
► Server and clients can work in a cross platform environment.
► Server can reside on one of the School Lunch program computers or on a separate computer.
► Server use requires more that basic computer skills for installation and maintenance.
A school or District computer technician or experienced user is required.
► Wireless connections are not recommended for posting meal and deposit reports but may
be suitable for other functions.