Feature request
jmeyer
Posts: 70 Bronze 2
I'm currently going through a refactoring exercise and utilize SQL Data Compare extensively. However, I am getting too many (in my mind) false positives due to the refactoring.
I'd therefore like to suggest the following new features:
1) Ability to ignore leading spaces (just as we can ignore trailing spaces)
2) Ability to better utilize (implicit) data type conversions when utilizing DATE and DATETIME/SMALLDATETIME data types. For example, if a value has no time component that the DATE, DATETIME and SMALLDATETIME data-typed values shodul eb considered identical
3) Ability to compare disparate data types based on the build-in SQL implicit data conversions, such that I can for example compare a VARCHAR column with an INT column. For example, I refactored a VARCHAR column to now be a TINYINT but I still want to be able to properly compare the values such that the VARCHAR '22' would be considered the equivalent of the TINYINT 22 value.
I'd therefore like to suggest the following new features:
1) Ability to ignore leading spaces (just as we can ignore trailing spaces)
2) Ability to better utilize (implicit) data type conversions when utilizing DATE and DATETIME/SMALLDATETIME data types. For example, if a value has no time component that the DATE, DATETIME and SMALLDATETIME data-typed values shodul eb considered identical
3) Ability to compare disparate data types based on the build-in SQL implicit data conversions, such that I can for example compare a VARCHAR column with an INT column. For example, I refactored a VARCHAR column to now be a TINYINT but I still want to be able to properly compare the values such that the VARCHAR '22' would be considered the equivalent of the TINYINT 22 value.
Comments
http://redgate.uservoice.com/forums/147 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
Product Support
Red Gate Software
This is what I like on your forums, the support is very friendly to the users.