Activity overview
Latest activity by Ken_Vitt
Invoke-DlmDatabaseSchemaValidation : The SQL Change Automation project folder
does not contain a single .sqlproj file.
/ comments
Invoke-DlmDatabaseSchemaValidation : The SQL Change Automation project folder
does not contain a single .sqlproj file.
Thanks - I was able to clone the repo perfectly fine. 1. I think i miss during nuget packageID maybe. How would i get this nuget packageID - is it the name of the database or do i need to do anything special? 2. Create temporary DBServer SQL localDB, where do i need to create this temporary DBServer SQL localDB ? or this gets created automatic on windows agent? - I think answers to these would be the key to get my dacpac file maybe? / comments
Thanks - I was able to clone the repo perfectly fine. 1. I think i miss during nuget packageID maybe. How would i get this nuget packageID - is it the name of the database or do i need to do anythi...
I looked at it and it's very generic. Me being new to database deployments with jenkins automation tool is getting little difficult. I think i need more help. Red-gate support provide any technical support services? / comments
I looked at it and it's very generic. Me being new to database deployments with jenkins automation tool is getting little difficult. I think i need more help. Red-gate support provide any technical...
I don't think i have a preference but i started of with conventional jenkins job here. I can convert job to pipeline as well but i need directions as i'm struck missing on some vital pieces. Thanks / comments
I don't think i have a preference but i started of with conventional jenkins job here. I can convert job to pipeline as well but i need directions as i'm struck missing on some vital pieces. Thanks
Is there anyway someone walk thru the steps obviously something is missing. / comments
Is there anyway someone walk thru the steps obviously something is missing.
I use git(bit-bucket). / comments
I use git(bit-bucket).
Thanks Maya & WayOutwest. I realized we do have the SCA plugin on Jenkins and followed the article however i got an error trying to build the DB. Here is the error msg Invoke-DlmDatabaseSchemaValidation : The SQL Change Automation project folder
does not contain a single .sqlproj file.
+ CategoryInfo : ReadError: [Invoke-DatabaseBuild], TerminatingException
+ FullyQualifiedErrorId : CanNotLocateASingleSqlProjFile,RedGate.Versionin
g.Automation.PowerShell.Commands.InvokeDatabaseBuildCommand
/ comments
Thanks Maya & WayOutwest. I realized we do have the SCA plugin on Jenkins and followed the article however i got an error trying to build the DB.Here is the error msgInvoke-DlmDatabaseSchemaValidat...
What's the guarantee that Powershell gallery will have SCA Powershell module. I see only thing we have is PowerShell Studio 2019 on software app store and i'm not sure if SCA Powershell module is available in Powershell Studio 2019 [image] / comments
What's the guarantee that Powershell gallery will have SCA Powershell module. I see only thing we have is PowerShell Studio 2019 on software app store and i'm not sure if SCA Powershell module is a...
So do i need to install SQL Change Automation tool separately or just a plugin in Jenkins will do the work? For instance there is MSBuild plugin available within Jenkins. So trying to check if that's all i need or separate software SQL Change Automation tool needed. If we need to install Red-gate SQL Change Automation as a tool then i have to deal with compliance issues. Anyway let me know. / comments
So do i need to install SQL Change Automation tool separately or just a plugin in Jenkins will do the work?For instance there is MSBuild plugin available within Jenkins. So trying to check if that'...
SQL DB Build & Deploy - Bit-bucket & Jenkins
Database - SQL ServerVersion control - GIT/Bit bucketAutomation - Jenkins pipeline.Question/task - I need to build sql database project & deploy thru jenkins pipeline.Currently we manually build & ...