I am trying to automate build and deployment of .Net windows service and SQL server scripts using Jenkins.
For .Net windows service, I am able to use MSBuild to create release exe/dlls. I have zipped the release folder and uploaded to Nexus.
For SQL server scripts, I have started using SSDT and able to create .dacpac file. I am also able to generate deployment script for a specific server using the .dacpac file. I have uploaded the .dacpac file to Nexus.
I am not sure what the best practices to deploy .Net artifacts from Nexus. I have the following questions:
How do I deploy .net Nexus packages? (do I unzip them and use InstallUtil to install the service?)
How do I deploy sql .dacpac Nexus package? (do I unzip the package and use SQLPackage to generate a script for the target database server?)
Are there any better ways to deploy .Net Nexus packages?