Activity overview
Latest activity by RomanPekar
It is indeed a matter of sheer volume. We have around a 1000+ procedures/functions, so just checking the list against migration log table takes some time. It's not much, but if there're multiple databases it adds up. My idea was to prepare smaller package using some "baseline". Let's say, I have versions 2.1, 2.4 and 2.5 deployed on different environments. I know that version 2.0 was for sure already deployed everywhere and I can use version 2.0 as a target to build a release package which then can be deployed to any environment. So the only changes which are going to be checked against migration log are changes that were done since version 2.0. / comments
It is indeed a matter of sheer volume. We have around a 1000+ procedures/functions, so just checking the list against migration log table takes some time. It's not much, but if there're multiple da...
Thanks for the answer @Peter_Laws I was thinking about rebaselining, which would reduce amount of scripts to be deployed,. The problem is most of our scripts are programmable objects so it's not going to help much. I'll try to think about other solutions. / comments
Thanks for the answer @Peter_Laws I was thinking about rebaselining, which would reduce amount of scripts to be deployed,. The problem is most of our scripts are programmable objects so it's not go...
New-DatabaseReleaseArtifact - is it possible to make it skip deployed scripts
I need to deploy one solution to multiple databases, and even though each deploy is relatively fast, if I deploy full solution using BuildArtifact it takes about 1 minute for each database to check...
@DanC Sorry but that doesn't really answer my question. My initial question was - is it possible to run New-DatabaseReleaseArtifact with -Target parameter being either nuget package or build arfifact object? Now you're giving me the script which uses connection object instead. I know that it works, but I want to be able to build release artifact without access to Sql Server. Could you adjust your script in a way that it uses either nuget package or build artifact and show me how it can be done? / comments
@DanC Sorry but that doesn't really answer my question.My initial question was - is it possible to run New-DatabaseReleaseArtifact with -Target parameter being either nuget package or build arfifac...
Hi @DanC Yes that's what is written in the documentation. However, when I'm trying to use Database Build Artifact as an example I receive the error which I mentioned in my starting post. Could you please check it out? Just to be sure, I run a test - I've created an empty SCA project, created a build artifact out of it and then tries to use it as a target parameter for release artifact. I still get the error: [image] [image] [image] Could you give me a simple reproducible example on how do I use such a parameter? I might be missing something / comments
Hi @DanC Yes that's what is written in the documentation. However, when I'm trying to use Database Build Artifact as an example I receive the error which I mentioned in my starting post. Could you ...
New-DatabaseReleaseArtifact doesn't support SQL Change Automation Build Artifacts as a target
I'm trying to adjust my pipeline for DB builds and want to use powershell cmdlets for that.To speed up the deployment I want to build a diff deployment package and I'm providing a target 'baseline'...
Greg_Smulko said:
We were able to identify the root cause of this issue and we're working on a permanent fix. For now, a workaround is to add the following line into a PropertyGroup in the .sqlproj: <SyncOptionIgnoreConstraintNotForReplicationAttribute>False</SyncOptionIgnoreConstraintNotForReplicationAttribute>Sorry for the inconvenience caused. For the future reference, regarding creating support tickets, please start from the https://productsupport.red-gate.com/hc/en-us page , where you can submit a request.
Hi Greg, Thanks, that was it! Seems to work fine now. I was going to create this request but I haven't seen anything meaningful in the logs of the new version so I was going to conduct proper test before I send it to you. / comments
Greg_Smulko said:
We were able to identify the root cause of this issue and we're working on a permanent fix.For now, a workaround is to add the following line into a PropertyGroup in the .sq...
Version 15.5.2 of VS3.0.18275.1681 of SQL Change Automation The solution only contain one project which is database project It´s happening on both new and converted projects
/ comments
Version 15.5.2 of VS3.0.18275.1681 of SQL Change Automation The solution only contain one project which is database projectIt´s happening on both new and converted projects
Greg_Smulko said:
Hi Roman, could you paste these 2 lines from the log file between which a gap occurs?
Greg, any new insights of the problem? Please let me know if we can expect some changes/advises or if we have to start looking into some workarounds. / comments
Greg_Smulko said:
Hi Roman, could you paste these 2 lines from the log file between which a gap occurs?
Greg, any new insights of the problem? Please let me know if we can expect some chang...
'Import and generate script' weird behavior
After update from ReadyRoll to SQL Change Automation I see very weird behavior of 'Import and generate script' button. So when I press the button, nothing happens (visually) and interface stays res...