Source control (using Git) does not commit newly created objects
-
- Posts: 5
- Joined: Fri 11 May 2018 13:59
Source control (using Git) does not commit newly created objects
I've configured the source control feature to use Git.
All works well when changing or removing existing objects in the database schema.
However new objects do not get committed into the repo.
Instead they are merely created in my working folder and seen as "Untracked" objects by Git.
Is there a setting I need to make in either Git or DbForge to force newly created objects to be committed into the repo?
I've included my .gitignore file contents below, in case something in there is the cause, but I don't think that's the case:
.vs/
#ignore obfuscation cruft
Obfuscated\ assemblies/
# Ignore User-specific files
*.suo
*.user
*.userosscache
*.sln.docstates
# Ignore NuGet Packages
*.nupkg
# The packages folder can be ignored because of Package Restore
**/packages/*
# except build/, which is used as an MSBuild target.
!**/packages/build/
# Uncomment if necessary however generally it will be regenerated when needed
#!**/packages/repositories.config
# Ignore Build results
[Dd]ebug/
[Dd]ebugPublic/
[Rr]elease/
[Rr]eleases/
x64/
x86/
build/
bld/
[Bb]in/
[Oo]bj/
# Ignore NUNIT
*.VisualState.xml
TestResult.xml
# Ignore Visual Studio profiler
*.psess
*.vsp
*.vspx
# Ignore ReSharper
_ReSharper*/
*.[Rr]e[Ss]harper
*.DotSettings.user
# Ignore DotCover
*.dotCover
# TeamCity
_TeamCity*
# Ignore Others
*.[Cc]ache
ClientBin/
[Ss]tyle[Cc]op.*
~$*
*~
*.dbmdl
*.dbproj.schemaview
*.pfx
*.publishsettings
publish/
*.lock
*.ide
*.tss
# Ignore backup & report files from converting an old project file
# to a newer Visual Studio version. Backup files are not needed,
# because we have git ;-)
_UpgradeReport_Files/
Backup*/
UpgradeLog*.XML
UpgradeLog*.htm
# sass
.sass-cache/
*_i.c
*_p.c
*_i.h
*.ilk
*.meta
*.obj
*.pch
*.pdb
*.pgc
*.pgd
*.rsp
*.sbr
*.tlb
*.tli
*.tlh
*.tmp
*.tmp_proj
*.log
*.vspscc
*.vssscc
.builds
*.pidb
*.svclog
*.scc
# RedGate Source Control
*.ssc
All works well when changing or removing existing objects in the database schema.
However new objects do not get committed into the repo.
Instead they are merely created in my working folder and seen as "Untracked" objects by Git.
Is there a setting I need to make in either Git or DbForge to force newly created objects to be committed into the repo?
I've included my .gitignore file contents below, in case something in there is the cause, but I don't think that's the case:
.vs/
#ignore obfuscation cruft
Obfuscated\ assemblies/
# Ignore User-specific files
*.suo
*.user
*.userosscache
*.sln.docstates
# Ignore NuGet Packages
*.nupkg
# The packages folder can be ignored because of Package Restore
**/packages/*
# except build/, which is used as an MSBuild target.
!**/packages/build/
# Uncomment if necessary however generally it will be regenerated when needed
#!**/packages/repositories.config
# Ignore Build results
[Dd]ebug/
[Dd]ebugPublic/
[Rr]elease/
[Rr]eleases/
x64/
x86/
build/
bld/
[Bb]in/
[Oo]bj/
# Ignore NUNIT
*.VisualState.xml
TestResult.xml
# Ignore Visual Studio profiler
*.psess
*.vsp
*.vspx
# Ignore ReSharper
_ReSharper*/
*.[Rr]e[Ss]harper
*.DotSettings.user
# Ignore DotCover
*.dotCover
# TeamCity
_TeamCity*
# Ignore Others
*.[Cc]ache
ClientBin/
[Ss]tyle[Cc]op.*
~$*
*~
*.dbmdl
*.dbproj.schemaview
*.pfx
*.publishsettings
publish/
*.lock
*.ide
*.tss
# Ignore backup & report files from converting an old project file
# to a newer Visual Studio version. Backup files are not needed,
# because we have git ;-)
_UpgradeReport_Files/
Backup*/
UpgradeLog*.XML
UpgradeLog*.htm
# sass
.sass-cache/
*_i.c
*_p.c
*_i.h
*.ilk
*.meta
*.obj
*.pch
*.pdb
*.pgc
*.pgd
*.rsp
*.sbr
*.tlb
*.tli
*.tlh
*.tmp
*.tmp_proj
*.log
*.vspscc
*.vssscc
.builds
*.pidb
*.svclog
*.scc
# RedGate Source Control
*.ssc
Re: Source control (using Git) does not commit newly created objects
We will review this post and will answer you as soon as possible.
-
- Posts: 5
- Joined: Fri 11 May 2018 13:59
Re: Source control (using Git) does not commit newly created objects
Update (yet more problems):
Now I also find that when I run a schema comparison and sync changes from another server's schema into my own schema, it does not reflect these changes in the source control manager.
Perhaps I have set up the sc settings incorrectly?
I have a local clone repo which is being tracked by a remote repo.
In sc manager, I have configured the remote repo's login credentials and have also tried to use the existing local clone as the "target" of sc.
However the properties window of the sc repo "unchecks" the "use existing local clone" option....?
See attached pic (https://www.dropbox.com/s/u9dx20nkaap38 ... s.png?dl=0).
What do I need to do to configure sc to work with my setup?
Now I also find that when I run a schema comparison and sync changes from another server's schema into my own schema, it does not reflect these changes in the source control manager.
Perhaps I have set up the sc settings incorrectly?
I have a local clone repo which is being tracked by a remote repo.
In sc manager, I have configured the remote repo's login credentials and have also tried to use the existing local clone as the "target" of sc.
However the properties window of the sc repo "unchecks" the "use existing local clone" option....?
See attached pic (https://www.dropbox.com/s/u9dx20nkaap38 ... s.png?dl=0).
What do I need to do to configure sc to work with my setup?
Re: Source control (using Git) does not commit newly created objects
Could you please specify the full product name?
-
- Posts: 5
- Joined: Fri 11 May 2018 13:59
Re: Source control (using Git) does not commit newly created objects
dbForge Studio for SQL Server
Enterprise Edition v5.5.327
Enterprise Edition v5.5.327
Re: Source control (using Git) does not commit newly created objects
Thank you for the reply.
We will investigate this issue and will answer you as soon as possible.
We will investigate this issue and will answer you as soon as possible.
Re: Source control (using Git) does not commit newly created objects
All changes, including objects adding, should commit automatically.
Are you using 'Dedicated' or 'Shared' database development model?
When creating a link to a remote repository, dbForge creates its own clone. It can be viewed in the 'Source Folder' field of the 'Source Control Settings' dialog url=https://www.devart.com/dbforge/sql/stud ... rol_ui.htm
Are there any other untrecked files apart from *.sql ones?
Are there any errors in the 'Error List' dialog (select 'View -> Error List' from the main menu)?
Also, we would appreciate if you could provide us with more detailed steps to reproduce it.
Are you using 'Dedicated' or 'Shared' database development model?
When creating a link to a remote repository, dbForge creates its own clone. It can be viewed in the 'Source Folder' field of the 'Source Control Settings' dialog url=https://www.devart.com/dbforge/sql/stud ... rol_ui.htm
Were you using the 'Use existing local clone' option or linking to a local folder?in my working folder
Are there any other untrecked files apart from *.sql ones?
Are there any errors in the 'Error List' dialog (select 'View -> Error List' from the main menu)?
Also, we would appreciate if you could provide us with more detailed steps to reproduce it.
-
- Posts: 5
- Joined: Fri 11 May 2018 13:59
Re: Source control (using Git) does not commit newly created objects
>> Are you using 'Dedicated' or 'Shared' database development model?
Dedicated
>> Were you using the 'Use existing local clone'
Yes
>> Are there any other untrecked files apart from *.sql ones?
No
>> Are there any errors in the 'Error List' dialog (select 'View -> Error List' from the main menu)?
Since I my posts, I have reverted to using the "Working folder" option to get back to work (this option works just fine).
In an effort to recreate the errors that happened earlier, I retraced my steps but then experienced a different behavior from DbForge:
1) Right click database in database explorer, select "Link Database to source control"
2) Select "Dedicated database development model"
3) Click "+" icon in "Source control repository" drop down
4) Choose Source control system: "Git"
5) Type in remote repository path (https://etc...), and type in under Security settings: HTTP login and password credentials (no client certificate is involved)
6) Clicked "Use existing local clone" checkbox, but....
Now my Remote repo settings have suddenly vanished and are replaced with "Using insecure connection" message.
In the past, they didn't vanish and I would have continued with the next step: clicking "three dots" and navigate to and select a (newly created by me) sub folder inside my existing repo on C: drive (e.g. C:\Users\admin\Documents\Visual Studio 2017\Projects\MyProject\TestDbForgeSqlSchemas)
Now I am unable to recreate what happened earlier because my remote repo is no longer active in the settings....
Dedicated
>> Were you using the 'Use existing local clone'
Yes
>> Are there any other untrecked files apart from *.sql ones?
No
>> Are there any errors in the 'Error List' dialog (select 'View -> Error List' from the main menu)?
Since I my posts, I have reverted to using the "Working folder" option to get back to work (this option works just fine).
In an effort to recreate the errors that happened earlier, I retraced my steps but then experienced a different behavior from DbForge:
1) Right click database in database explorer, select "Link Database to source control"
2) Select "Dedicated database development model"
3) Click "+" icon in "Source control repository" drop down
4) Choose Source control system: "Git"
5) Type in remote repository path (https://etc...), and type in under Security settings: HTTP login and password credentials (no client certificate is involved)
6) Clicked "Use existing local clone" checkbox, but....
Now my Remote repo settings have suddenly vanished and are replaced with "Using insecure connection" message.
In the past, they didn't vanish and I would have continued with the next step: clicking "three dots" and navigate to and select a (newly created by me) sub folder inside my existing repo on C: drive (e.g. C:\Users\admin\Documents\Visual Studio 2017\Projects\MyProject\TestDbForgeSqlSchemas)
Now I am unable to recreate what happened earlier because my remote repo is no longer active in the settings....
Re: Source control (using Git) does not commit newly created objects
We were not able to reproduce it.
After the step 6, please specify the path to the folder (or sub-folder in this folder) into which you were making a clone. This way, Security settings will display again.
After the step 6, please specify the path to the folder (or sub-folder in this folder) into which you were making a clone. This way, Security settings will display again.
-
- Posts: 5
- Joined: Fri 11 May 2018 13:59
Re: Source control (using Git) does not commit newly created objects
Yes, that did the trick.
Recreating the steps now seems to work for some reason.
Whatever the problem was, it's gone now.
Thanks for your time and feedback...
Recreating the steps now seems to work for some reason.
Whatever the problem was, it's gone now.
Thanks for your time and feedback...
Re: Source control (using Git) does not commit newly created objects
Thank you for updating us on this issue. Please let us know if any questions arise.