Comments
                          
                            Sort by recent activity
                          
                          
                        
                      
                      
                        Apologies for the issues. I haven't seen this, but I haven't done an SCA deploy lately with VSTS. I'll try to give this a test soon and confirm.  / comments
                        
                        
                        
                      
                      
                      
                  
                    Apologies for the issues. I haven't seen this, but I haven't done an SCA deploy lately with VSTS. I'll try to give this a test soon and confirm.
                      
                    
                      
                        This works for me. Note that your post has the "DECLARE @... TABLE" on the commented line. I assume that's not the case in SSMS.   Highlight the code, then format. 
   Prompt 9.1.10    [image]   / comments
                        
                        
                        
                      
                      
                      
                  
                    This works for me. Note that your post has the "DECLARE @... TABLE" on the commented line. I assume that's not the case in SSMS.Highlight the code, then format.
Prompt 9.1.10
                      
                    
                      
                        I was thinking to use SQL Compare,or even run a deployment to the Shadow database, using the SCA package that's created. Just point the .ps1 to the shadow database and update things.  I haven't gotten in this situation, and not sure I can recreate it. Haven't had time today, but perhaps I can try to upgrade an old project and see what happens.  / comments
                        
                        
                        
                      
                      
                      
                  
                    I was thinking to use SQL Compare,or even run a deployment to the Shadow database, using the SCA package that's created. Just point the .ps1 to the shadow database and update things.I haven't gotte...
                      
                    
                      
                        The Shadow db is what is compared. This should be updated to the current version. You could use Compare to do this, but I think you could specify a new Shadow to "reset" the comparison  / comments
                        
                        
                        
                      
                      
                      
                  
                    The Shadow db is what is compared. This should be updated to the current version. You could use Compare to do this, but I think you could specify a new Shadow to "reset" the comparison
                      
                    
                      
                        Is your shadow database the same as the "original" version?   / comments
                        
                        
                        
                      
                      
                      
                  
                    Is your shadow database the same as the "original" version? 
                      
                    
                      
                        Can you provide more information about what "amend the schema" means? Can you repro this? There should be support for temporal tables, but it's possible you have found a bug.  / comments
                        
                        
                        
                      
                      
                      
                  
                    Can you provide more information about what "amend the schema" means? Can you repro this? There should be support for temporal tables, but it's possible you have found a bug.
                      
                    
                      
                        You can use this workaround to lower/change the refresh: https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/10217469-stop-automatic-page-refresh-while-reviewing-schema
   Frankly, I'd expect we could configure this. I'll lobby for an enhancement here. 
    / comments
                        
                        
                        
                      
                      
                      
                  
                    You can use this workaround to lower/change the refresh: https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/10217469-stop-automatic-page-refresh-while-reviewing-schema
Frankly, I...
                      
                    
                      
                        You can use this workaround to lower/change the refresh: https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/10217469-stop-automatic-page-refresh-while-reviewing-schema
   Frankly, I'd expect we could configure this. I'll lobby for an enhancement  
    / comments
                        
                        
                        
                      
                      
                      
                  
                    You can use this workaround to lower/change the refresh: https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/10217469-stop-automatic-page-refresh-while-reviewing-schema
Frankly, I...
                      
                    
                      
                        You can use this workaround to lower/change the refresh: https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/10217469-stop-automatic-page-refresh-while-reviewing-schema
   Frankly, I'd expect we could configure this. I'll lobby for an enhancement  
    / comments
                        
                        
                        
                      
                      
                      
                  
                    You can use this workaround to lower/change the refresh: https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/10217469-stop-automatic-page-refresh-while-reviewing-schema
Frankly, I...
                      
                    
                      
                        Glad to hear that. and again, my apologies that there hasn't been more work in this area. I'm trying to advocate for resources, since I think this is a good product that is both useful for customers and for our story.  / comments
                        
                        
                        
                      
                      
                      
                  
                  
                Glad to hear that. and again, my apologies that there hasn't been more work in this area. I'm trying to advocate for resources, since I think this is a good product that is both useful for customer...