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. This article describes how to...
Fri, 19 Jul, 2019 at 3:13 PM
Creating an Empty SQ Lite Database
This article describes how to create a new, empty SQ Lite database for your SystemWeaver installation.  Prerequisites Server and database compatible v...
Fri, 23 Aug, 2019 at 10:21 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 ...
Thu, 18 Feb, 2021 at 8:26 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.  Prerequisites Server and database compatible version of ...
Mon, 21 Oct, 2019 at 1:48 PM
How to Clone 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,...
Thu, 18 Feb, 2021 at 8:36 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...
Thu, 15 Apr, 2021 at 9:41 AM
Creating the Internal Database (for non-SQLite databases)
If your organization is setting up a new an MS SQL or Oracle database for a SystemWeaver server to connect to, you will need to create the internal database...
Thu, 4 Jun, 2020 at 12:57 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 with an option t...
Thu, 18 Feb, 2021 at 8:20 AM
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
How to Resolve a DB Integrity Error
When starting the SystemWeaver server (either by directly executing the server or using the swTestServer GUI), the following error is thrown "ERROR sws...
Fri, 12 Jun, 2020 at 8:51 AM