Im looking to incorporate docker as part of my CI pipeline and one perfect usecase would be for running database migrations and tests against a docker container like so:
Right now i have a static database and ofcource if two developers check in conflicting migrations we have a problem.
build source -> spin up a sqlserver container -> run migrations -> run tests and then tear it down again.
Now my problem is that i want to do this for multiple parallell builds, and obviously i cant bind multiple containers to the same port on my host so i could use some advice on how i could possibly solve this.
Im using GitLab to trigger build on commit and build on mergerequest jobs in Jenkins.
Thanks in advance