There are many reasons you may need a SQL script that captures table, view, column, and key properties.
It all boils down to comparing different states to quickly identify what changed, or what is different.
- Maybe you need to quickly isolate what got missed in the migrations from DEV to TEST environments.
- Maybe you need to quickly identify what changed between this release (AFTER) and the prior release (BEFORE).
- Maybe you want to run the script daily and output state snapshots to text files so that in the event of an emergency you can quickly identify what changed between given dates.
Using your favorite text diff-ing tool, here is what two sample schemas (PPMO-OldSchema vs. DEV-NewSchema) might look like side-by-side (red markup lines added):
If you like these scripts, be sure to click the "Star" button above in GitHub.
Also, be sure to visit or subscribe to our YouTube channel www.DataResearchLabs.com!
Links to the script source code as well as video tutorials are listed below, by platform (MSSQL, Oracle, MySQL, etc.):
|
|
|
|
|
|
|
|
|
|
|
|
|
|