The following SQL databases are currently supported by SystemWeaver:
- SQLite
- MS SQL Server (see Checklist for MS SQL Database)
- Oracle
Systemite highly recommends using SQLite in part because of the performance advantages over the others.
SQLite
+ No latency as the SQLite file is stored on the SystemWeaver server.
+ Fastest start-up time.
+ No costs for additional hardware. The file is stored on the same machine as the server.
+ Runtime backup option provided.
The benefits of future optimization of SystemWeaver will be greater for systems running SQLite.
For instructions on how to create a new SQLite database, see Creating an Empty SQ Lite Database.
What's Next?
Browse our Database Management articles.