How can we help you today? How can we help you today?

Installing a Flyway Desktop Repository on Microsoft OneDrive

Has anybody attempted to set up a repository on their Microsoft OneDrive?  I work off two different computers and wanted my repositories to sit in OneDrive so that both computers could access them.  I was able to create a Desktop Flyway project on OneDrive with no issues.  I exited the project, made a change to my Dev Database, and reopened the project.  As expected the Flyway project discovered the issue, but when it went to save it to the repository on OneDrive, I received an error stating that it did not have permissions to write to the directory.  It's strange that it was able to create folders and files but then not able to save to them later on.  

I was just wondering if anybody else has attempted this, and if so did you have to resolve this issue?
JimmyG
0

Comments

3 comments

  • JimmyG
    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
    0
  • graded
    Check if the files are syncing correctly between devices or if OneDrive is running in a "read-only" state for some reason.
    graded
    0
  • Nathaniel Jude

    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
    0

Add comment

Please sign in to leave a comment.