Warning for Updates that will Take a Long Time
clethert
Posts: 2 New member
in SQL Compare
Is there a way to flag changes that will take a long time to apply? If not, I would love if you could add that. Right now, it seems like there is a warning when a table rebuild is required (very helpful), but there is no warning if a non-nullable column with a default is added to a large table, for example - even though that could take a long time and cause a lot of blocking. I realize what qualifies as a "large table" is going to vary by situation, but it would be nice if there was a way to flag if an update is going to have to touch every row in a table and the table has more than n rows.
Tagged:
Best Answer
-
David Atkinson Posts: 1,461 Rose Gold 2@clethert - Doing this in SQL Compare might be interesting. I think that we don't currently analyze the target database for table sizes so would have to fetch the stats and use this to decide whether to trigger a warning. Is this what you had in mind?David Atkinson
Product Manager
Redgate Software
Answers
Product Manager
Redgate Software