February 27, 2019 at 4:29 am
Any recommendations on good online tutorials? We are starting to use those tools but the only internal information is very high level. I'm looking for basic "Dummies" types guides to start with then more detailed after I get the basics.
March 1, 2019 at 12:31 pm
Github, Lots of stuff out there. There are a few git tutorials here:
- https://www.atlassian.com/git/tutorials
- https://try.github.io/
- https://learngitbranching.js.org/
- https://voiceofthedba.com/tag/git/ (my stuff)
Jenkins - Haven't seen a great tutorial. Mostly poked around and it made sense because I'd used TeamCity. I might recommend video first, because it's easier to make sense of where things are. That's how I learned, someone showed me a few things.
- https://www.youtube.com/watch?v=yz3tyeA3Fe0 (some history, but a good overview of what it is)
- Honeslty, because of the JAva stuff and it's a lot going on, I like the tutorials here with containers being used: https://jenkins.io/doc/tutorials/ The python one made sense.
Octopus - Might listen to Damian here. I like him and he does a good job explaining things. Demo here. https://www.youtube.com/watch?v=xJXz6AXEiQ4
The thing you really need to do is get vcs set up first. I'd actually do this with hello world in C/Python/etc. to get used to committing code. If you want to do this with db code, then start with a few .sql files and pre-create the dbs. Use SQLCMd to execute the files. Hard code things to start, like server names, auth, etc.
Once you have code, learn to get that into a build with Jenkins. I'd start with a step that compiles the code and produces a package. If you want to do db stuff, add a step to create a db, then a step to run your code (.sql files with sqlcmd) and a step to drop the db. Or a pre-step to drop the db if it exists.
At that point, use octopus to set up a feed spot and a plug in (https://wiki.jenkins.io/display/JENKINS/OctopusDeploy+Plugin) to push your package to Octopus. From there, you play with the steps needed to deploy the code somewhere.
Side note: The reason Redgate builds tools for db stuff is to make this really easy.
March 6, 2019 at 4:49 am
Thanks, Steve. This helps.
March 14, 2019 at 4:31 pm
Good luck. Post more questions if you have them.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply