I recommend reading Vladimir Khorikov's excellent post: https://enterprisecraftsmanship.com/posts/database-versioning-best-practices/.

The main choice is between state based and migration based.

I'd recommend Database Projects (for MSSQL) aka dacpac for state based and DBUp for migration based.

If you have money to spend look into https://www.red-gate.com/products/flyway/