Comments
Sort by recent activity
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...
@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...