Hi everyone,
first time poster here but im hoping someone could help me.
Im currently developing a Windows service that connects to an Oracle dataset and monitors the database for any changes, not data being added, but more changes to table attributes or creating additional columns etc. When it detects a change it will email a number of users to notify them.
Connecting to the database and the email parts i have done but im not sure how to go about creating the code that does the database monitoring.
My initial idea was to take a snapshot of the database and store it then using a timer take another snapshot and simply compare the two but ive no idea how to go about doing that.
Does anyone have any ideas how i can do this.
Pete
first time poster here but im hoping someone could help me.
Im currently developing a Windows service that connects to an Oracle dataset and monitors the database for any changes, not data being added, but more changes to table attributes or creating additional columns etc. When it detects a change it will email a number of users to notify them.
Connecting to the database and the email parts i have done but im not sure how to go about creating the code that does the database monitoring.
My initial idea was to take a snapshot of the database and store it then using a timer take another snapshot and simply compare the two but ive no idea how to go about doing that.
Does anyone have any ideas how i can do this.
Pete
