Framework for Monitoring Metadata changes
It is really important for a handshake model to exist between most upstream and downstream systems. Normally there is a mode of communication between the upstream Dev and Downstream Dev teams in order to track these changes. Now I have created a simple framework. Now rather than a pull system where the downstream pulls the meta data changes from the source, I have created a push system that the upstream will send across to the destination systems. Let us see how the framework works: Step 1: Create a table that will store the metadata changes like addition or updation of tables and views as follows- --Table to store Metadata changes for views and tables CREATE TABLE DB_Table_View_Changes ( DB_Table_View_Changes_ID INT IDENTITY(1,1) PRIMARY KEY ,DB_Schema_Name VARCHAR(256) ,DB_TableView_Name VARCHAR(256) ,DB_TableView_Type VARCHAR(5) ,ModifiedDate DATETIME ) Step 2: The next step is to create the table that will track the Column changes made to views or tables- --Table to t...