Comments
Sort by recent activity
I think I found the answer here: https://documentation.red-gate.com/sca3/getting-started/requirements/powershell-component-requirements Apparently linux Jenkins nodes won't fly. / comments
I think I found the answer here: https://documentation.red-gate.com/sca3/getting-started/requirements/powershell-component-requirements Apparently linux Jenkins nodes won't fly.
Thanks @Dan B. It felt awkward to me because I had set up the connection to the dev DB multiple times but when I clicked on the "finish setting up the project", it did not show that connection. It asked for me to connect to a dev DB. As far as I was concerned, I was done setting up the project. It's a minor annoyance, but still felt like a bug. So, yes, please send this on to the devs. Thank you, -Peter / comments
Thanks @Dan B. It felt awkward to me because I had set up the connection to the dev DB multiple times but when I clicked on the "finish setting up the project", it did not show that connection. It ...
oops / comments
oops
Gotcha. Thank you, @way0utwest. / comments
Gotcha. Thank you, @way0utwest.
Oddly,I am not able to select @way0utwest 's response as the answer to my question... / comments
Oddly,I am not able to select @way0utwest 's response as the answer to my question...
@Eddie D and @Monday , thanks for the replies. Eddie, I am aware of the docs you suggested. That still requires the ops DBA to use powershell to deploy, so it's not an option until I socialize that possibility. Currently, I'm trying to automate as much as possible before delivering them a sql file. I would like to see an option to set various SQLCMD vars in the packagescript.sql when I call invoke-databaseBuild. / comments
@Eddie D and @Monday , thanks for the replies. Eddie, I am aware of the docs you suggested. That still requires the ops DBA to use powershell to deploy, so it's not an option until I socialize that...
One more comment for RG folks: I would still expect the PackageVersion SQLCMD var to be populated in the PackageScript.sql after I call Export-DatabaseBuildArtifact, since we are required to call that cmdlet with a PackageVersion parameter. / comments
One more comment for RG folks: I would still expect the PackageVersion SQLCMD var to be populated in the PackageScript.sql after I call Export-DatabaseBuildArtifact, since we are required to call t...
I guess it makes sense that package version might not be set since I can actually get the PackageScript.sql without calling Export-DatabaseBuildArtifact. Re: ReleaseVersion, I understand that I could set it in the project on the SQLCMD vars tab, but I want it to be dynamically set via powershell. Since Invoke-DatabaseBuild doesn't have a SqlCmdVariables param like New-DatabaseReleaseArtifact does, I don't see a programmatic way to set release version other than processing the file, which I have to do anyway side the SQLCMD setvar section is commented out anyhoo. / comments
I guess it makes sense that package version might not be set since I can actually get the PackageScript.sql without calling Export-DatabaseBuildArtifact.Re: ReleaseVersion, I understand that I coul...
Thank you, @Russell D I'm using SCA. I've read the SCA docs on data. That didn't quite get me there, though. I want to use a where clause filter in the SCA project, like I can do inside SQL data compare. / comments
Thank you, @Russell D I'm using SCA. I've read the SCA docs on data. That didn't quite get me there, though. I want to use a where clause filter in the SCA project, like I can do inside SQL data co...
Thanks, @Monday. So, you're not getting the server name check code section in your TargetedDeploymentScript.sql? I always get it, and I don't have any special drift settings set (all default). Is there a different way to run the New-DataBaseReleaseArtifact that will generate a TargetedDeploymentScript.sql without the check? I still need to pass a single SQL script (can be SQLCMD) to the ops DBAs that will deploy the latest changes (to multiple target DBs/servers). They are not yet willing to run a PS script. I'm trying to avoid using the MSBuild generated scripts, too, but willing to consider if that seems like the right approach. / comments
Thanks, @Monday. So, you're not getting the server name check code section in your TargetedDeploymentScript.sql? I always get it, and I don't have any special drift settings set (all default). I...