Database Management
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
This article describes how to create a new, empty SQLite database for your SystemWeaver installation, or testing purposes. Prerequisites Server and d...
Fri, 17 May, 2024 at 11:49 AM
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
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
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
This article provides some configuration support for implementation and maintenance of a MS SQL database for SystemWeaver. Ensure Stable Connection To...
Tue, 9 Jul, 2024 at 4:40 PM
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
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
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
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