Comments
Sort by recent activity
Couldn't agree more, Mr Yates. Our org moves... s l o w l y [image] / comments
Couldn't agree more, Mr Yates.Our org moves...slowly
Thanks, @AlexYates. I figured as much - just wanted to make sure I wasn't missing anything. I do like having a version stamp in individual DBs as it helps to identify version as they get backed up and restored elsewhere. Could even be an extended property. It's also helpful while we don't have CI servers in place. Post-deploy script option seems reasonable. Thank you, -Peter / comments
Thanks, @AlexYates. I figured as much - just wanted to make sure I wasn't missing anything. I do like having a version stamp in individual DBs as it helps to identify version as they get backed u...
No, but I do have Import-Module SQLChangeAutomation in the script. / comments
No, but I do have Import-Module SQLChangeAutomation in the script.
Hi @Dan B. Apologies for the delay in my reply. This was using powershell cmdlets in a powershell script - not a CI plugin. So, the question is how to turn off powershell gallery check in the individual cmdlets. / comments
Hi @Dan B. Apologies for the delay in my reply. This was using powershell cmdlets in a powershell script - not a CI plugin. So, the question is how to turn off powershell gallery check in the i...
@Eddie D Please see my previous post. I am unable to match filehashes using PowerShell's Get-FileHash with the hash value in script_schecksum. Can you tell me how I can get matching hash, please? / comments
@Eddie D Please see my previous post. I am unable to match filehashes using PowerShell's Get-FileHash with the hash value in script_schecksum. Can you tell me how I can get matching hash, please?
None of the algorithms available in PS's GetFilehash match what I'm finding in the script_checksum column in __MigrationLog. / comments
None of the algorithms available in PS's GetFilehash match what I'm finding in the script_checksum column in __MigrationLog.
Thanks, Eddie. I have been checking this by using powershell's Get-FileHash, and I'm not getting a match. For example, in my __MigrationLog, one of my scripts (attached) shows a checksum of: E0F10404E1FDCBBEF178991783B426B5FCF4BA2A906DDF75CFB54DF025721EDB but using Get-FileHash -Algorithm SHA256 gives me: 222A98897E8773854BED4584B70176BA74188E5EA1D28A8ADE8DB1E1A2B59941 I've also checked my git history and none of my migrations that SCA was warning about has changed. / comments
Thanks, Eddie. I have been checking this by using powershell's Get-FileHash, and I'm not getting a match. For example, in my __MigrationLog, one of my scripts (attached) shows a checksum of:E0F10...
@Monday, I think my issue is similar, but not the same. Wondering how I could actually generate the script checksum of a migration file and compare to what I find in the __MigrationLog table. / comments
@Monday, I think my issue is similar, but not the same. Wondering how I could actually generate the script checksum of a migration file and compare to what I find in the __MigrationLog table.
I'm a bit confused, @Monday . How did you resolve the issue? / comments
I'm a bit confused, @Monday . How did you resolve the issue?
Thanks, @Monday. Are you suggesting that I work with the: <SyncOptionIgnoreWhiteSpace>True</SyncOptionIgnoreWhiteSpace>setting in the sqlproj file? Or something different? / comments
Thanks, @Monday. Are you suggesting that I work with the:<SyncOptionIgnoreWhiteSpace>True</SyncOptionIgnoreWhiteSpace>setting in the sqlproj file? Or something different?