Guide: Migrate boltdb to sqlite

[Firxiao]

Hi there!
I've created a tool set that can be used to migrate data from BoltDB to SQLite, and I hope it helps.
I've tested it with version v2.16.19 of SemaphoreUI.

Here's how you can use it:

1. First, upgrade your SemaphoreUI to version v2.16.19 (which uses BoltDB).
2. Extract the data using the bolt2json tool from this repository: bolt2json
3. Then, run SemaphoreUI with SQLite to generate a new empty SQLite database.
4. Use my migration tool to read the exported data and convert it into plain SQL statements.
5. Import these SQL statements into your SQLite database.
6. Finally, restart SemaphoreUI and check if all your data has been successfully migrated.
   You can find more detailed information about the migration tool here: semaphore-migration

If you're in a hurry to migrate to SQLite, you can try my tool. Otherwise, you can wait for the official migration scripts.

[ray0711]

worked very well, two small things:

• the migration guide could add a hint about running sqlite database.sqlite < migrated_data.sql
• the selected inventory wasn't migrated for my task definitions. That could be quickly corrected by setting it via gui for each task.

Thanks a lot for the migration tooling