Suggestion: list SQL errors before synchronisation
CrispinH
Posts: 57
At the moment if there are any SQL errors found at synchronisation time only the first error is shown in a pop-up. This is a nuisance if there are actually multiple errors that need resolving. It would be a useful if there could either be something on the Tools menu that would check the database integrity and list all the errors that are going to be found at sync time.
Regards
Crispin
Regards
Crispin
Comments
The good news is that we are hoping to add a feature to SQL Prompt that will identify such objects, allowing you to fix all the problems in your database in one go.
Kind regards,
David Atkinson
Red Gate Software
Product Manager
Redgate Software
Objects that no longer exist or have been renamed pretty much sums it up.
Glad to hear that SQL Prompt will fix it in the future. However, it would also be useful to be able to run a check from SQL Compare because that's where the problem will be mercilessly exposed.
Crispin
David
Product Manager
Redgate Software
Redgate Software