Generation of SQL Alter queries on the difference in the structures of tables in the database?

Question

SQL

There is a development-instance of SQL Server, on which a DBMS is running with a bunch of tables. During the development process, some tables are altered, stored procedures are added, new tables are added.
Then all this needs to be transferred to the production-instance. And the more changes (and every time it gets bigger) - the longer it takes to finish the production-instance to a state suitable for use with the new version.
Accordingly, the question is: is there such a software that would produce a script at the output that changes the production base to the development version?

Answer 1

mySQlDiff has such a tool that can help

Answer 2

Reg Gate Sql Compare
or alternatively VisualStudio > Menu > Data > Schema Compare

Answer 3

If for SQL Server only, then I would suggest looking at dbForge Schema Compare for SQL Server . A very, very worthy tool, plus a free edition.

Answer 4

Use a database version control system such as liquibase . The diff scripts are very unreliable because they compare the difference between the end result and the start result and have no way of knowing what was in between. For example, if you renamed a table, drop table + create table might be generated instead of rename.

Answer 5

I've been having the same problem as you for many years now. All systems for automated generation of change scripts often do not work correctly or skip the necessary elements.
We still force all developers to write a system change script, then we collect all scripts from developers in a batch update. And already on the working bases we roll all these batch updates.
We maintain precise version control of all updates, and detailed SQL scripts for all these updates.