Comments
Sort by recent activity
SQL Data Compare option support is currently on our backlog and work is scheduled to start soon.
This is great news! I am also interested in defining which columns in a table are used or can be ignored for data compare. / comments
SQL Data Compare option support is currently on our backlog and work is scheduled to start soon.
This is great news! I am also interested in defining which columns in a table are used or can be ig...
Before you figure out how to resolve it, make sure you know what the issue is. Did you compare your db to your project with sql compare and the only difference was white space? If so then you have the same issue that I had. (You are telling it to ignore white space and it is not) I fixed my issue by making the objects in the DB the same as the objects in the project by matching white space as a temp fix while they fixed the bug in the SCA code. Alternatively this may be a bug in the version of the cmdlet you have that was fixed or was just introduced? To me, SCA thinks there is a difference for some reason, so the place to start is to find out what that difference is. / comments
Before you figure out how to resolve it, make sure you know what the issue is. Did you compare your db to your project with sql compare and the only difference was white space? If so then you have ...
I think we need redgate to chime in with what algorithm they are using to produce the checksum. get-filehash does not match any of the 7 it supports. / comments
I think we need redgate to chime in with what algorithm they are using to produce the checksum. get-filehash does not match any of the 7 it supports.
No I had mine set to true in the sqlproj file but the VS extension was not honoring it. To see this I used SQL compare but in SQL compare you [image] need to uncheck ignore white space to see it. Check out this thread here. / comments
No I had mine set to true in the sqlproj file but the VS extension was not honoring it. To see this I used SQL compare but in SQL compare you need to uncheck ignore white space to see it. Check ou...
I found a bug a few weeks back that affected comparing white space. It was in the VS extension but maybe it is also in certain versions of the cmdlets. I was able to see this by using SQL compare to compare my VS project against the database. Make sure you have the setting in SQL compare to include white space. Might not be the issue but something to check. / comments
I found a bug a few weeks back that affected comparing white space. It was in the VS extension but maybe it is also in certain versions of the cmdlets. I was able to see this by using SQL compare t...
This looks to be the same issue but on octopus instead of jenkins. https://forum.red-gate.com/discussion/84067/octopus-step-templates-throws-always-warning-about-f-anonymoustype0-1 / comments
This looks to be the same issue but on octopus instead of jenkins. https://forum.red-gate.com/discussion/84067/octopus-step-templates-throws-always-warning-about-f-anonymoustype0-1
This sounds great and I would be happy to help contribute code. / comments
This sounds great and I would be happy to help contribute code.
I was just working on a script to generate the NuGet package version and I ran across this page today. https://docs.microsoft.com/en-us/nuget/reference/package-versioning I assume your issue is that the -Suffix must start with a alpha character. The one that worked started with -e the ones that failed start with -0. / comments
I was just working on a script to generate the NuGet package version and I ran across this page today. https://docs.microsoft.com/en-us/nuget/reference/package-versioningI assume your issue is that...
@PeterDaniels You posted this as a discussion not a question. I have done this before as well. / comments
@PeterDaniels You posted this as a discussion not a question. I have done this before as well.
PackageVersion is for the version of the Nuget package. In my process I publish the package to a Nuget feed and other tools will know when to pick it up based on that version. I don't think PackageVersion applies to you since you are manually handing the script to your Ops. Redgate should probably address the other questions. On a side note it would be nice to see Redgate take a little time in making some guides, documentation, strategy , videos, etc for people using SCA like this. I think this is and will be a common approach to introduce the tool in baby steps while building up confidence or waiting for resources to free up to implement. A lot of the documentation and marketing is geared towards CI/CD and that's a great goal but in the real world a lot of us need to take a phased , agile approach. / comments
PackageVersion is for the version of the Nuget package. In my process I publish the package to a Nuget feed and other tools will know when to pick it up based on that version. I don't think Package...