When the time comes to deploy your application and database changes, ReadyRoll and Octopus Deploy make a great team.
ReadyRoll is a Visual Studio plug-in that automatically generates numerically ordered SQL migration scripts for you, so that you take your schema from one version to the next.
Use ReadyRoll to carefully prepare your database migrations – column additions, stored procedure changes, SQLCR assemblies, or static data.
Add the changes to version control, and then use Octopus Deploy to automate the release of your database and application deployments, all in one process.
Read more documentation – Here
Hope this will help !!!