Comments
Sort by recent activity
Hi @GurpreetGill, SQL Change Automation uses SQL Compare internally so that's why you saw this message. I think I reproduced your issue and there was a problem trying to update SQL Change Automation from the Powershell Gallery. We've release a new version of the Azure DevOps extensions (3.0.5 for Build and 3.0.3 for Release). Could you please try it and see if it resolves your problem? Thanks / comments
Hi @GurpreetGill,SQL Change Automation uses SQL Compare internally so that's why you saw this message.I think I reproduced your issue and there was a problem trying to update SQL Change Automation ...
If you're using Git in Azure DevOps you should treat as git repository when you want to link your database. https://documentation.red-gate.com/soc7/linking-to-source-control/link-to-git / comments
If you're using Git in Azure DevOps you should treat as git repository when you want to link your database.https://documentation.red-gate.com/soc7/linking-to-source-control/link-to-git
Hi @mikko, Are you trying to connect to TFS repository in Azure DevOps now? The multiple identities found error seems related to Azure DevOps to me not to SQL Source Control. / comments
Hi @mikko,Are you trying to connect to TFS repository in Azure DevOps now? The multiple identities found error seems related to Azure DevOps to me not to SQL Source Control.
@duncanbatchelor I may have missed some detail but I think you could have kept the data in the table if you had written written your script to first add the new columns, after that put the data in those new columns and only as a third step you would alter the table to add the default constraint. Then you could remove the old columns from both the table and the view and make the view use the new columns. / comments
@duncanbatchelor I may have missed some detail but I think you could have kept the data in the table if you had written written your script to first add the new columns, after that put the data in...
I've tried to replicate this but I've not been able to. Some things we can check: - Are you using connecting with some credentials that do not have permission for that DB? - Does unlinking and linking again help? - Does it show the indicator if you create a new database and link it?
/ comments
I've tried to replicate this but I've not been able to.Some things we can check:- Are you using connecting with some credentials that do not have permission for that DB?- Does unlinking and linking...
Hi gTech, That's seems unsual. Which version of SQL Source Control and SSMS are you using? / comments
Hi gTech,That's seems unsual. Which version of SQL Source Control and SSMS are you using?
Hi @staggerlee011 There a couple of documentation pages. I've added the links below. https://documentation.red-gate.com/display/SCA3/Use+the+VSTS+Build+extension+with+SQL+Change+Automation+Project https://documentation.red-gate.com/display/SCA3/Use+the+VSTS+Release+extension Hope this helps. / comments
Hi @staggerlee011 There a couple of documentation pages. I've added the links below.https://documentation.red-gate.com/display/SCA3/Use+the+VSTS+Build+extension+with+SQL+Change+Automation+Projectht...
I think that with git you should be able to to just switch branches without relinking every time. / comments
I think that with git you should be able to to just switch branches without relinking every time.
Hi @sramsay, I think you could select which objects you want on each commit and then the message could be more focused on that specific change. / comments
Hi @sramsay,I think you could select which objects you want on each commit and then the message could be more focused on that specific change.
Hi @PeterDaniels, I'm afraid we don't expose that at the moment. / comments
Hi @PeterDaniels,I'm afraid we don't expose that at the moment.