Upgrading to MariaDB
Overview The ‘UnityIS to New MariaDB Database’ function in the Data Import Utility is used to migrate existing sites that use either MS Access or SQL Server to the MariaDB data engine. This tool should be used instead of the Access2SQL tool...
Move a Block of Access Levels to the End
Overview As a system ages, Access Levels that were created at the beginning may become less often used. In which case it may become necessary to organize the more frequently used Access Levels to the top, by moving the less frequently used ones to...
Upgrading to PostgreSQL
Overview PostgreSQL is an open source Relational database management system (RDBMS) that has a significantly smaller footprint than SQL Server. There are no database size limits with PostgreSQL, and it outperforms MS Access and SQL Server. Steps t...
Re-Indexing SQL Tables
Overview Large SQL database tables need to be re-indexed periodically. This can be scheduled to run once a month using SQL Management Studio. Below are sample scripts that can be executed to re-index large tables. Events Table: ALTER INDEX ALL ON ...