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.

SQL Data Flow
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.

Server Requirements:

Any windows computer running Microsoft SQL 2005 or later:
Microsoft SQL Server 2005 / Server 2005 Managements studio
Microsoft SQL Server 2005 Express / Server 2005 Managements studio
Microsoft SQL Server 2008 / Server 2008 Managements studio
Microsoft SQL Server 2008 Express / Server 2008 Managements studio
Microsoft SQL Server 2008 R2 / Server 2008 Managements studio
Microsoft SQL Server 2008 R2 Express / Server 2008 Managements studio
Microsoft SQL Server 2012/ Server 2012 Managements studio
Microsoft SQL Server 2012 Express / Server 2012 Managements studio
Microsoft SQL Server 2014/ Server 2014 Managements studio
Microsoft SQL Server 2014 Express / Server 2014 Managements studio

 

User Requirements:

  • Microsoft Windows XP, Vista, Windows 7, Windows 8.x, or Windows 10
  • 64 MB of RAM
  • 40 MB of available hard disk space
  • Microsoft Access 2007 or later

(if you do not have Microsoft Access, you may download a free runtime version from Microsoft  https://www.microsoft.com/en-us/download/details.aspx?id=10910)

For additional information contact:
Sales@SundayBizSys.com
Tel: 408-217-9680

Click here to download the full Tech Note.