changes from dev to prod

Question

in the past I had used sql compare to compare changes between dev and prod to propagate changes.

what are the best ways to propogate sql changes latest version from dev to prod

Answer 1

Hi NeophyteSQL,

SQL Server Data Tools for Visual Studio enables you to analyze and compare database schema and data and apply changes on the target database or to generate T-SQL scripts to run later.
https://dbmstools.com/categories/schema-compare-tools/sqlserver

https://dba.stackexchange.com/questions/80142/deploying-sql-server-database-changes-from-test-to-production-server

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I think one of the tools to compare two database definitions is the Schema Compare utility in the SQL Server Data Tools (SSDT). Take a look at "How to: Use Schema Compare to Compare Different Database Definitions".