Databases Overview
The StrataBugs application must be connected to a database with the correct schema version. This database may be on a local filesystem or a remote server, either within your organisation or in the public cloud.
Supported Platforms
-
Oracle
-
SQL Server
-
PostgreSQL
-
H2
Could be supported: MySQL
No longer supported: Microsoft Access
Hosting
StrataData can facilitate cloud hosting for a PostgreSQL database. Please contact us for details and pricing.
Schema and Application Versions
The StrataBugs data model, or schema, has evolved over time as new features are added to the application. Although we update the application frequently, we don’t change the data model except in a major release. The first two parts of the application version number relate to the data model version.
The database version 3.0 is compatible with all application versions 3.0.x, but would not work with application versions 3.1.0 or 2.1.1.
When we do need to update the schema, existing databases will need to be either upgraded in place (typically adding new fields and tables), or copied to an entirely new schema which has some more structural changes. If a simple in-place update is possible, we increment the minor version field (e.g., move to v3.1).
Depending on the size and complexity of your database, migrating to another version may be a straightforward task, or a longer project requiring some careful planning and analysis.