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 Jun, 2023 at 11:35 PM
Creating an Empty SQ Lite Database
This article describes how to create a new, empty SQLite database for your SystemWeaver installation, or testing purposes.  Prerequisites Server and d...
Tue, 11 Jul, 2023 at 8:17 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...
Tue, 15 Aug, 2023 at 9:04 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 To...
Mon, 13 Mar, 2023 at 2:13 PM
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 Oracle database for a SystemWeaver server to connect to, you will need to create the internal database th...
Tue, 20 Dec, 2022 at 9:13 AM
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 with an option t...
Wed, 15 Mar, 2023 at 1:53 PM
How to Resequence Version Chains
Should unexpected version chains appear, for example, after importing data from another database, there is a tool in the Database Manager that can be used t...
Fri, 12 Jun, 2020 at 8:44 AM