Activity overview
Latest activity by G4734
Hi Eddie, Thanks again for looking into this for us, We managed to find a work around, for what we are trying to do which is to use the latest SQLCover within our SqlChangeAutomation database project build without SQLCover.dll being stored in SourceCode. Normally (.Net) you could create a dependency using the NuGet Package Manaer within the project but because SqlChangeAutomation projects in Visual Studio are based on .sqlproj projects and these type of projects don't allow you include NuGet dependancies, we had to look at a different way: Solution was to include a package.config <?xmlversion="1.0" encoding="utf-8"?> <packages> <package id="GOEddie.SQLCover"version="0.5.0" targetFramework="net461" /> </packages> And then to add the following to .sqlproj file <ItemGroup> <PackageReference Include="GOEddie.SQLCover" Version="0.5.0" /> </ItemGroup> We then add a NuGet Restore task in the build pipline pointing it at the package.config and this seems to do the required job / comments
Hi Eddie,Thanks again for looking into this for us, We managed to find a work around, for what we are trying to do which is to use the latest SQLCover within our SqlChangeAutomation database projec...
Hi Eddie,
Thanks again for looking into this for us,
We managed to find a work around, for what we are
trying to do which is to use the latest SQLCover within our SqlChangeAutomation
database project build without SQLCover.dll being stored in SourceCode.
Normally (.Net) you could create a dependency using the NuGet Package Manaer within
the project but because SqlChangeAutomation projects in Visual Studio are based
on .sqlproj projects and these type of projects don't allow you include NuGet dependancies,
we had to look at a different way:
Solution was to include a package.config
<?xmlversion="1.0" encoding="utf-8"?> <packages> <package id="GOEddie.SQLCover"version="0.5.0" targetFramework="net461" /> </packages>
And then to add the following to .sqlproj file
<ItemGroup> <PackageReference Include="GOEddie.SQLCover" Version="0.5.0" /> </ItemGroup>
We then add a NuGet Restore task in the build
pipline pointing it at the package.config and this seems to do the required job / comments
Hi Eddie,
Thanks again for looking into this for us,
We managed to find a work around, for what we are
trying to do which is to use the latest SQLCover within our SqlChangeAutomation
database proj...
Hi Eddie, thanks for coming back to me, We are using a specific Enterprise SQL instanace specially provisioned for SQL builds, as far as I can see the project builds so I'm not 100% sure why - during the build - this warning is appearing? I would assume that this warning would be more appropriate when I'm actually running the tests and code analysis which is the next step in the ADO pipline. It's at this stage that I'm trying to figure out how we get these libraries onto the build machine which does not nativley have them installed? / comments
Hi Eddie, thanks for coming back to me,We are using a specific Enterprise SQL instanace specially provisioned for SQL builds, as far as I can see the project builds so I'm not 100% sure why - durin...
Could not locate the assembly "Microsoft.SqlServer.TransactSql.ScriptDom"
During the Invoke-DatabaseBuild in ADO, I am getting warning indicating that ..ScriptDom and ..SQLCover libraries are unabled to be located. Although they are warnings, we'd like to resolve these.W...
Powershell comandlet to Build dependant project(s)
Hi,We have a situation where we would like build and deploy a database locally using SCA, the set-up is slightly more complex as it consists of a red-gate database project (project.ABC) that is dep...