SQL Source Control will not show new objects on Commit tab

• 
  Hi @tomslickers
  
  Can you try unlinking and relinking your database from the repository? It will refresh the working base folder and transient folder that SQL Source Control uses behind the scene. Here is how things works behind the scene: https://documentation.red-gate.com/soc6/reference-information/how-sql-source-control-works-behind-the-scenes
  
  

  Tianjiao_Li September 03, 2018 13:25

  - 0 +
• 
  That worked. Thanks!
  

  tomslickers September 03, 2018 21:54

  - 0 +
• 
  Hi @Tianjiao_Li ,

       
  

  I encounter the same problem months ago and I knew I can unlink and re-link the git repository to show the new added stored procedure, I have done this operation months ago. Actually I  have no idea how to reproduce it.

  Today I encounter the same problem again, I wonder if you can fix this. It's a little  frustrated to do the boring operation.
  

  
  

  chuck November 09, 2019 09:35

  - 0 +
• 
  Is the linked database a shared dev DB or does each developer have their own?

  David Atkinson November 09, 2019 10:06

  - 0 +
• 
  Hi @David Atkinson ,
         We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab.
         The weird thing is, my colleague add about 10 stored procedures. But only one of them was sh

  chuck November 09, 2019 10:18

  - 0 +
• 
  If you do a Git pull on your instance and refresh the vomit tab, does this help?

  David Atkinson November 09, 2019 10:35

  - 0 +
• 

  David Atkinson said:

  If you do a Git pull on your instance and refresh the vomit tab, does this help?

  Actually my colleague did not use sql source control, I will add his stored procedure into git repository.
  So I almost don't need to use git pull feature.

  chuck November 09, 2019 10:41

  - 0 +
• 
  So you’re both modifying the same database? And procedures you add are always fine but your colleague is mostly shown in the get latest screen?

  David Atkinson November 09, 2019 11:45

  - 0 +
• 
  Hi @David Atkinson,
       Yes, we modify the same database.
       My procedures are  always fine and my colleague's procedure mostly fine, sometimes it will show on get latest tab.
        For example, my colleague add 10 procedures, 9 of them will shown on commit tab, but 1 of them was shown on get latest tab.
  
  

  chuck November 09, 2019 15:22

  - 0 +
• 
  Hi @David Atkinson ,
         We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab.
         The weird thing is, my colleague add about 10 stored procedures. But only one of them was shown as dropped on get latest tab, the others are shown as new added on commit tab.

  chuck November 15, 2019 09:03

  - 0 +
• 
  Hi @David Atkinson ,
         We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab.
         The weird thing is, my colleague add about 10 stored procedures. But only one of them was shown as dropped on get latest tab, the others are shown as new added on commit tab.

  chuck November 15, 2019 09:03

  - 0 +

Add comment

Please sign in to leave a comment.