Here is the scenario.
Our company have 2 databases, database DEV is used for development and database PROD is the actual database used for our applications.
The developers are using DEV database to create or alter tables, store procedures and so on. After they finish the development phase, they need to deploy the modification to PROD database.
The point is this deployment is not a backup and recover process that means we only sync the database schema from DEV to PROD and we do not sync any data or record.
Could anyone please give me a suggestion to automatically achieve this requirement by sql query?