Migrating project data to a new server?

As far as I know, there are two ways to achieve this.

  1. Dump the whole database as mentioned in Backup AYON database/settings
  2. Migrate project by project via
    • in your current ayon-docker, dump the project data
      make dump projectname=YourProjectName
      
    • copy storage/server/projects/YourProjectName to the new docker location.
    • in the new ayon-docker
      make restore projectname=YourProjectName dump.YourProjectName.sql
      

I’m following the second approach in my AYON Dev Wrokbench here

Note, this also backup the task assignees which may raise an error/warning if the assigned users don’t exist on the new instance.