Non intrusive way of capturing the schema changes with out using trigger:Can we track the changes with read-only access to the servers?
At present set up scripts needs to be run in each environment which requires certain elevated privileges in each environment and needs continuous tracking. As the schema does not change often can we have an option to track every 30 minutes read only pull from server than push from the server based on triggers? We want this tracking to be non intrusive to the system that it wont add additional resource overhead and happens in a controlled way
As I understand it, the DDL triggers only fire when a DDL statement is run. That should be very minimal overhead especially since you mention you don't have a lot of changes. When that trigger fires, it inserts the RedGate database. That database is polled by the DLM Dashboard.
It sounds to me like your suggestion would have every database polled for all object metadata each interval. Unless I'm misunderstanding your suggestion, I think that would be significantly more overhead.