Comments
Sort by recent activity
OK that's an idea Alex. Only downside is we'd have to remember (or I guess it could be automated) to include any changes (i.e. it wouldn't be caught by SSC's "Commit" tab if a change was made to the trigger in-DB). / comments
OK that's an idea Alex. Only downside is we'd have to remember (or I guess it could be automated) to include any changes (i.e. it wouldn't be caught by SSC's "Commit" tab if a change was made to t...
OK Dan I haven't seen a reoccurrence since but if I do I'll raise a support ticket. Thanks. / comments
OK Dan I haven't seen a reoccurrence since but if I do I'll raise a support ticket. Thanks.
Thanks Dan. Filtering extended properties by name seems work ones that are against the database itself (at least when we've done it in the past). Do you think it's a bug/issue that it doesn't work the same way for ones against stored procedures? / comments
Thanks Dan. Filtering extended properties by name seems work ones that are against the database itself (at least when we've done it in the past). Do you think it's a bug/issue that it doesn't wor...
Ok cool, that was at the back of my mind as well and is likely the way we'll go but it was worthwhile checking I wasn't overlooking something more obvious or easier. Thanks. / comments
Ok cool, that was at the back of my mind as well and is likely the way we'll go but it was worthwhile checking I wasn't overlooking something more obvious or easier. Thanks.
OK thanks, I'll have an attempt to change it to be a powershell script (I had been using Powershell when testing). Only challenge I see is working out the agent paths to use, but I'm sure that's documented somewhere, just haven't gone to that level in Azure Devops as yet. / comments
OK thanks, I'll have an attempt to change it to be a powershell script (I had been using Powershell when testing). Only challenge I see is working out the agent paths to use, but I'm sure that's d...
Yeah where there was a will there was a way, and the toolset managed to get it done. Even with it only the blanking of files they immediate showed as modified in Git so I had a list of what to delete. Thanks again! / comments
Yeah where there was a will there was a way, and the toolset managed to get it done. Even with it only the blanking of files they immediate showed as modified in Git so I had a list of what to del...
Ok thanks David, I'll give that a try. Hadn't really been leveraging SQL Compare for anything, so this'll be a good learning experience. / comments
Ok thanks David, I'll give that a try. Hadn't really been leveraging SQL Compare for anything, so this'll be a good learning experience.
David, Yep your suggestion worked, with a few comments:
Using File -> "Create Scripts Folder..." in SQL Compare 13, I couldn't figure out how to select/specify the existing Filter.scpf. Ended up using the command line sqlcompare.exe.
Would be good if there were SQL Compare Powershell cmdlets.
Once I had generated the scripts folder, I used the GUI to compare and found the extra files in repo. I used SQL Compare to apply the "deletion" however it seemed to only remove the contents of the SQL file, not delete it (that may have been something to do with my options in SQL Compare).
However those comments aside I managed to do what I required, so thanks! Cheers Peter / comments
David,Yep your suggestion worked, with a few comments:
Using File -> "Create Scripts Folder..." in SQL Compare 13, I couldn't figure out how to select/specify the existing Filter.scpf. Ended up us...
Me too on this as well. Definitely nothing showing in git "status", nothing to git "stash" etc. / comments
Me too on this as well. Definitely nothing showing in git "status", nothing to git "stash" etc.