Configure poll intervals
Can we have control over how often the source control / database is polled for changes? I see the changes are reflected almost immediately but reallly i dont need it to run that often - Can you let me configure how often the change polling occurs.
The option to control poll intervals is now available from the Setup tab in the Frequent Updates build, and will be available in the next main version of the product.
If you want to get the Frequent Updates builds, more details can be found at http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates
Andy Joiner commented
I was discouraged from version controlling my live database, because of the polling. This change would allow me to track live (for good measure).
First choice: Use a schema change to kick off polling.
Second choice: Eliminate the XML editing by adding a UI element.
Rob Warthen commented
Making use of extended events or something on the SQL Server would really be ideal. As it is right now, it really does take time away from programming and becomes disruptive.
Ideally you would be able to make use of the extended events mechanism or a server-scoped trigger to keep track of DDL events and only have to do an incremental scan of the schema. This should be a lot faster than doing the whole thing from scratch each time.
I agree, it would be better if this was a feature available within the tool.