Copy Database

If you want to copy the data from a SQLite database into a freshly created database to ensure all the database structure is correct after upgrades.

You can run the following command from the FileFlows Servers command line interface

Generic

Open a terminal into the FileFlows/Server directory.

dotnet FileFlows.Server.dll --copy-db --src ../Data/FileFlows.sqlite --dest ../Data/FileFlows-new.sqlite

Docker

Open a console to the FileFlows Server Docker container

cd /app/Server
dotnet FileFlows.Server.dll --copy-db --src /app/Data/Data/FileFlows.sqlite --dest /app/Data/Data/FileFlows-new.sqlite

If this command works successfully, you can then backup your original FileFlows.sqlite file and replace it with the new database you created.

---

--src

This needs to be the file of the source database you are copying the data from

--dest

This is the new database file that will be created with the data copied over.