Detect new databases and add automatically
We run 1 database per customer and are constantly adding databases, they follow a specific naming convention.
Having some way to auto add those databases to environments would help, or at a minimum alerting there are unmonitored databases on a server.
As an idea auto add based on
1) based on naming convention filters for database name
2) We would happily add a redgate table to our schema with an entry to specify environment etc for auto pickup
3) Schema is within X % of other databases of same type
Mickey Stuewe commented
Also add the ability to be alerted that there is a new database before the database is added. I've had a database added to the wrong server before.
I would love to see the create date, the user who added/restored the database, and the database name with server name.