What is SQLite?
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
Why is Datacap switching Terminal-based NETePay's from SQL Server to SQLite?
Migrating from SQL server to SQLite has the following benefits:
- SQLite is built-in to NETePay - You don't have to download, install, and maintain an instance of MS SQL Server.
- Easier Install - Since SQLite is built into NETePay, there’s no need to worry about pre-requisites or compatibility with pre-existing databases.
- Makes back-ups easier - To perform back-ups, all you need to do is exit NETePay and copy the file.
What do I have to do when switching from SQl Server to SQLite?
When switching from NETePays using SQL Server to NETePays using SQLite, make sure you close any open batches before making the switch. In order to view back-ups from previous terminal-based versions of NETePay, you will need to keep SQL Server installed.