With SQL Source Control, you would have to use Redgate's SQL Compare or SQL Change Automation to deploy database changes to downstream environments (e.g., Version Control > Test > Production).

With Flyway, state-based deployments are part of the solution.  You can do manual state-based deployments, automatic state-based deployments as part of a CI/CD pipeline, or adopt a migrations-based deployment approach if you need more control over the scripts ran at deployment time. 

Learn more about State-Based Deployments in Flyway.