Database support
Using different relational databases
SafetyCulture Exporter supports exporting data to MySQL
, PostgreSQL
, and SQL Server
databases. Depending on the system and database you use, you may need to complete additional configurations before exporting. Alternatively, you can also run exports by supplying the database dialect and connection string flags in the command line.
For example (if you're using these examples to fill out your YAML config file, you only need the part after --db-connection-string
):
- MySQL:
./safetyculture-exporter sql --db-dialect mysql --db-connection-string user:pass@tcp(127.0.0.1:3306)/dbname?charset=utf8mb4&parseTime=True&loc=Local
Refer to the Data Source Name for the connection string’s supported formats. - PostgreSQL:
./safetyculture-exporter sql --db-dialect postgres --db-connection-string postgresql://user:pass@localhost:5434/dbname
- SQL Server:
./safetyculture-exporter sql --db-dialect sqlserver --db-connection-string sqlserver://user:pass@localhost:1433?database=dbname
Refer to the Connection Parameters and DSN for the connection string’s supported formats.
Updated 6 months ago