I'm working on a .NET Core application that uses MySQL as its database. I need to set up a CI/CD pipeline in GitLab to automate the process of database migrations. My goal is to ensure that every time new code is pushed to the repository, the MySQL database is automatically migrated to the latest schema version. Can someone help with that as I'm not able to get enough information on it?
I have already tried using Flyway and DBUp, but not able to get any successful outcome.
