Database Management

Which Database Version Are We Running?
The SystemWeaver database version gets updated from time to time. When it does, we'll announce this in our release notes. SystemWeaver databases can sti...
Tue, 20 Oct, 2026 at 10:27 PM
Creating an Empty SQLite Database
This article describes how to create a new, empty SQLite database for your SystemWeaver installation, or testing purposes.  Prerequisites Server and d...
Thu, 13 Mar, 2025 at 11:18 AM
How to Copy MS SQL Database to SQLite Database
Although SystemWeaver is compatible with MS SQL, for top performance and lowest cost, we recommend SQLite: No latency as the SQLite file is stored on the ...
Tue, 11 Jul, 2023 at 8:20 AM
How to Copy SQLite Database to MS SQL Database
This article describes how to complete a data pump from a SQLite database to a MS SQL database.  Confirming SQLite Database Version Creating SystemWea...
Wed, 23 Apr, 2025 at 10:47 AM
How to Clone a Database to an SQLite Database
There are some cases where an independent copy of an existing database is needed. Mostly this is for testing new releases of SystemWeaver before deployment,...
Tue, 11 Jul, 2023 at 8:15 AM
Checklist for MS SQL Database
This article provides some configuration support for implementation and maintenance of a MS SQL database for SystemWeaver.  Ensure Stable Connection Low ...
Wed, 23 Apr, 2025 at 10:45 AM
Compacting Large SQLite Files
The swDatabaseManager tool includes an option called Vacuum SQLite database which will minimize the SQLite database file. The benefit of this is that the sh...
Thu, 8 Feb, 2024 at 9:56 AM
Creating the Internal Database (for non-SQLite databases)
If your organization is setting up a new MS SQL or PostgreSQL (available with releases R53 and later) database for a SystemWeaver server application to conn...
Tue, 20 Oct, 2026 at 10:38 PM
How to Back Up the Database
Depending on which database type you are running, the backup process will be different. Systemite offers a runtime backup option for SQLite databases. It cr...
Tue, 15 Apr, 2025 at 4:48 PM
Updating the Database Version
The database version identifies the version of the internal database schema used by SystemWeaver. Each server version normally works with exactly one databa...
Tue, 20 Oct, 2026 at 10:28 PM