Are there any best practices for migration-based deployments?

sdunn

We're using TFS to build and Octopus to deploy. We'd like to incorporate any SQL Change Automation best practices that may be out there to ensure our development team make best use of the tool.

Any advice, suggestions, good (and bad) habits etc?

Tianjiao_Li

Hi @sdunn

We have some help articles for migration-based deployments, and I'd recommend you to take a look first.
https://www.red-gate.com/hub/product-learning?topic=database-development-in-visual-studio

Once you've have SQL Change Automation project up running, you can try to automate the deployment by following the instructions stated on bellow page: 
https://documentation.red-gate.com/sca/deploying-database-changes/automated-deployments-with-sql-change-automation-projects

You may also find some useful videos in our Youtube channel and 
https://www.youtube.com/playlist?list=PLhFdCK734P8B6c78JliKyv2U0StNC0Skc
Redgate University:
https://www.red-gate.com/hub/university/sql-change-automation

Should you have any specific areas that you are looking for suggestions, please do let us know.