Is it possible to support git worktree feature for SQL Source Control?

Currently we have a database diverged, and we a v5 on production and v6 on develop environment.
We would like to maintain two versions of database at the same time.

Here are steps how to create a worktree folder for git repository:

1.mkdir MyDatabase

2. cd MyDatabase

3. git clone url main

4. cd main

5. git worktree add -b v5 ../v5 origin/v5 (create a new branch based origin/v5, and create worktree folder for the new created branch)

6. git worktree add -b v6 ../v6 origin/v6

After these steps, you will get three folders main、v5、v6 under MyDatabase folder.

When I try to link the database to the v5 worktree folder by SQL Source Control, I got red error info "That folder isn't a git repository". However I can use git bash and TortoiseGit in the work tree folder v5 and v6.

SQL Source Control should recognized the worktree folder as the others did. By the way, here is a .git file in new created worktree folder which contains main folder path. You might check this.


Best Answer

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    Answer ✓
    I'm afraid that SQL Source Control does not support that feature.
    Our recommendation in this case would be to link to the Git Clone using the Working Folder option and then use Git Bash or a third party Git tool to interact with the Git repository.
    If you wish to you can suggest this feature on our Uservoice forum at https://redgate.uservoice.com/forums/39019-sql-source-control , that forum is monitored by the Product Management team who use it as an important source when deciding on new features.

    Kind Regards,
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.