Visual Studio Data Tools Here

Use SQL Database Projects to define your schema. Instead of writing individual ALTER scripts, you define the "target state" of your database. The tool compares your project to a live database and generates the necessary deployment scripts automatically.

At its core, VSDT provides a unified environment for managing the entire lifecycle of a data project. visual studio data tools

This is a powerful utility that compares two database schemas (e.g., a Project vs. a Live Database, or Database A vs. Database B). Use SQL Database Projects to define your schema