Installing a Flyway Desktop Repository on Microsoft OneDrive

• 
  I probably should have researched the Flyway Support site better before posting this, as it is recommended by Redgate not to do this for this very reason...
  
  https://documentation.red-gate.com/flyway/learn-more-about-flyway/troubleshooting/projects-in-onedrive
  

  JimmyG December 30, 2024 16:39

  - 0 +
• 
  Check if the files are syncing correctly between devices or if OneDrive is running in a "read-only" state for some reason.

  graded January 15, 2025 22:19

  - 0 +
• 

  I’ve actually run into a similar issue when trying to use Microsoft OneDrive as a repository location. The core problem is that OneDrive syncs files in a way that can sometimes lock or restrict permissions when applications (like Flyway) try to write directly into the synced directory. That’s why you were able to initially create the project and folders, but later faced errors when Flyway attempted to save new changes.

  A couple of things you can try:

  1. Check OneDrive Sync Settings – Ensure “Files On-Demand” is disabled. When enabled, OneDrive may store files in the cloud only and fetch them on demand, which often breaks repository-based tools.
  2. Local Path Exclusion – Set up your repository in a standard local directory (e.g., C:\Repos\Project) and then use OneDrive Backup or Sync to mirror that folder to the cloud. This way, Flyway interacts with a normal file system while OneDrive handles syncing in the background.
  3. Permissions – Right-click on the OneDrive repository folder and make sure your account has full read/write permissions. Occasionally, inherited permissions get messed up during sync.
  4. Alternative Sync – Some developers avoid putting repositories directly in OneDrive and instead rely on Git remote hosting (like GitHub, GitLab, or Bitbucket) for synchronization, while using OneDrive strictly for backup.

  Others have reported that while OneDrive is fine for regular file storage, it’s not always reliable for active repositories due to conflicts and permission locks. If you’re frequently switching between two computers, Git remotes may be the more stable solution.

  Nathaniel Jude August 26, 2025 07:26

  - 0 +
• 

  Thanks for sharing this setup. Installing a Flyway Desktop repository inside a OneDrive-synced folder can be convenient for backups, but it’s important to be careful with sync conflicts—especially when multiple machines or users are involved. Similar to installing applications like Roblox for PC, Flyway Desktop on a Windows PC works best when files are stored in a stable, locally managed location. For database migrations, using proper version control (such as Git) instead of relying solely on OneDrive syncing can help avoid issues like file locking, partial syncs, or unexpected conflicts.

  Anke Drechsler December 23, 2025 17:16

  - 0 +

Add comment

Please sign in to leave a comment.