How to create a modify table script for all tables

Question

I'm always facing a problem that when I modify tables on a dev database I forget to make the same changes on production machines. It's also hard (and tedious) to remember all the changes I made if i make a lot of them.

Is there some sort of solution to update production database/tables programmatically, or similar to getting latest version of files from version control?

Answer 1

What I do is I simply just compare the Dev database and production database(or a backup copy of Dev database which I took before making any changes).

There are a lot of tools available to compare schema and data of 2 databases. One such tool is redgate's SQL compare