We have a situation where the mapping of databases, tables, and some columns differs between our dev and production SQL servers, and this is detrimental to development. Things will work on dev, and then be interrupted due to sort conflicts during progress, data and structures will be copied from prod to dev, which in turn interrupts requests for dev due to conflicts, etc. We will work around this, either by explicitly defining COLLATION in the query sometimes, or by assigning a match to each column in the insult table to get around it. The first seems to amaze performance, and the second - PITA.
Is there any script or anything that might show sorting inconsistencies or information about the database and objects, or any suggestions on how to automatically reconcile the differences so that we can synchronize the situation?
In addition, any advice on debugging sort conflicts in a query would also be good ... I never know where the conflict really is, and ultimately you have to go through it and redefine it ... sigh .... it's a mess .
Thanks for any ideas!
source
share