I need to write a script which compares the source and target database and identify the following structure differences on daily basis. The source database is constantly changing so need the capture the addition/modification of columns and fix it in target db.
1. Addition of new column in source db
2. Change of data type in source db
3. Change of data length in source db
The differences needs to be fixed by the script by executing dynamic ALTER TABLE statement for all the differences listed above.
Please can anyone help?