Database Tools

This section contains articles that relate to database management.

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...

Avatar

By IMRON Corporation

March 22, 2022

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...

Avatar

By IMRON Corporation

July 27, 2021

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...

Avatar

By IMRON Corporation

March 22, 2022

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 ...

Avatar

By IMRON Corporation

March 22, 2022

Connect To MariaDB From A Different Machine

To connect to your database server remotely using the MariaDB client, follow these steps: NOTE:  Ensure that your virtual machine has a local network IP address. To configure your virtual machine to connect to your local network, refer to these in...

Avatar

By IMRON Corporation

July 19, 2023