Tech Note: SQL Based Software Solutions

Sunday Business Systems offers SQL versions of our standard products. From the user perspective, the SQL version is identical to our demo version except the underlying data is stored in Microsoft SQL tables. The user interface, or Microsoft Access front end, connects to the SQL back end through our proprietary DSN-less Technology. Our DSN-less Technology allows easy connection without having to create and maintain individual ODBC links from each user’s computer.

Figure 1. Overall network structure of SQL product (the SQL server may reside also on the Network file server)

SQL versions provide a higher level of data and user security while providing the same user experience and performance. SQL administrators may add additional levels of user security and automated back-up strategies to protect sensitive company data.

To install the SQL version of our product, your company must provide the Microsoft SQL server and the database administration. We will provide the database files for installation. Free versions of the Microsoft SQL Server (Server Express) are available if your company does not already have a SQL server installed.

Once purchased, you will receive the software via email. The software is in 2 parts: a Microsoft Access front end and a SQL Back-end. Your IT folks will need to install the back-end SQL database on your SQL server, save the front end database on a network file server, and link the front end to the back end.

The installation process is simple and usually takes less than 15 minutes.