• Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Features
    • Asset Management
    • Bespoke Certificates
    • Catering Certificates
    • CRM
    • Customer Portals
    • Diary
    • Electrical Certificates
    • Engineer Portals
    • F-Gas
    • Fire and Security Certificates
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Notifications
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
    • Validation
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • Air Conditioning
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
    • Pools
    • Cleaning
    • Renewable Energy
    • PAT Testing
    • Gas
    • Pest Control
    • Drainage
    • Telecommunications
    • Audio Visual
    • Laboratory Equipment
    • Water Services
    • HVAC
    • Construction
    • Environmental
    • Healthcare and Medical
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
Contact Us Try for FREE
  • Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Features
    • Asset Management
    • Bespoke Certificates
    • Catering Certificates
    • CRM
    • Customer Portals
    • Diary
    • Electrical Certificates
    • Engineer Portals
    • F-Gas
    • Fire and Security Certificates
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Notifications
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
    • Validation
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • Air Conditioning
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
    • Pools
    • Cleaning
    • Renewable Energy
    • PAT Testing
    • Gas
    • Pest Control
    • Drainage
    • Telecommunications
    • Audio Visual
    • Laboratory Equipment
    • Water Services
    • HVAC
    • Construction
    • Environmental
    • Healthcare and Medical
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
return to Support Centre

SQL Version Explained

Benefits Of SQL

The original version of the NICEIC software has been created in an Access database, which can easily run from a PC. This can handle a few users and their cert data but starts to struggle and slow down when there are multiple users accessing the software at the same time. With the SQL version, you can see the below improvements:

Speed Improvements

Firstly, an SQL server is optimised to work much more quickly than a client machine, particularly when dealing with several users and large amounts of data.

Secondly, the amount of data sent across the network link is vastly reduced. For most databases, the main performance bottleneck is data transmission over the network, so reducing this can give a dramatic improvement in performance.

Predicting performance improvements is very difficult but an average overall speed improvement of 3 to 5 times, and possibly much more, would not be unexpected.

Greater Reliability

With Access, each user reads and writes directly into the raw data of the software. If one of their machines crashes while writing something this will usually cause the back-end database to also crash and become corrupt. The same thing will occur if the network fails, has a glitch or temporarily becomes overloaded. This problem becomes more apparent as the amount of data or the number of users increases.

With an SQL server, users do not interact directly with the back-end data but with an intelligent data manager on the server. This then reads and writes data from and to the back-end software. If a users machine crashes, or the network hiccups, this will not affect the underlying database; instead the data manager realises that the transaction has not been completed and does not commit the partially transmitted data to the database. The database, therefore, continues to run without a problem.

Multiple Concurrent Users

A file server system, such as access, is designed for small groups and is best suited to run with up to about 10 concurrent users. Above this level, performance starts to degrade rapidly as more users are added. With the SQL server, hundreds of concurrent users can be supported without a noticeable negative impact on its performance.

 

What do we need to get set up with the SQL version of NICEIC Cert Software?

If you currently have the NICEIC Cert Software set up on a server with users accessing it, then chances are you will be able to get the SQL version put onto the same server. If you currently share the software from a user’s machine, then we would recommend setting up a server before implementing the SQL version.

However, there are some server requirements. This can be dependent on the number of users accessing the SQL.

 

Server Requirements:

  • Intel® Core i5/i7/Xeon CPU or equivalent
  • 16GB RAM or higher
  • Windows Server 2012 R2, 2016, 2019 & 2022 – (for best performance we recommend the SQL database is not to be installed on a server with Microsoft Exchange).
  • Microsoft .NET Framework 4.7.2 (or higher)

Clik will need to install a version of SQL onto your server. If you already have SQL installed, we can just install a new instance.

 

What happens after we process the request?

Once you request the SQL version of the software, we’ll get in touch with your IT department, and arrange access to the server you would like the NICEIC SQL database to be installed on. We will then begin getting everything set up in the background for you.

When SQL has been set up, we will need all your users to come out of the software to complete the conversion. The time this takes can vary depending on your database size but we estimate it to take between 15-45 minutes. After this, we can liaise with your IT department to ensure all your users are running the SQL database and not the old database.

If you need anything else explained about the benefits of SQL or have any requirement questions, please get in touch with our team on 0117 902 2012.

NICEIC Cert Software

NICEIC Cert Software

General

NICEIC Cert Software FAQs
NICEIC Cert Software

NICEIC Cert Software

General

NICEIC Cert Software Overview [Video]

General

  • NICEIC Cert Software Overview [Video]
  • NICEIC Cert Software FAQs
  • Running Software Updates
  • Running and Scheduling Syncs
  • Restoring Deleted Records
Show more

Ask Tech a Question

Did you find what you were looking for? Don’t worry if not, you can get in touch with our tech support team.

Contact Tech Support
PERSONALISED LEARNING

A Training Masterclass From Our Experts

You’ve got the software. Now get the expert knowledge straight from the experts. If you want to know more about Clik Service or the NICEIC Cert Software, maybe you want to drill down into a specific module, or a run-through for a new engineer, we’ll walk and talk you through it in the way that suits you.

Learn More

4.5

  • Products
    • Clik Service
    • Clik Jobs
    • Clik Remote
    • NICEIC Cert Software
    • Clik Cert
    • View All Products
  • Features
    • CRM
    • Invoicing
    • Job Management
    • Job Scheduling
    • Quoting
    • View All Features
  • Industries
    • Air Conditioning
    • Electrical
    • Facilities Management
    • Fire and Security
    • Plumbing
    • View All Industries
  • Support
    • Training
    • Service Status
    • Contact Tech Support
    • Product Roadmap
  • About
    • Blog
    • News
    • Privacy
    • Terms

Copyright Clik Limited © 2000-2023 – All Rights Reserved