Activity overview
Latest activity by ross
Brian Donahue wrote:
For my clarification, is the workaround to put the text
SET LANGUAGE us_English
at the top of the SQL Script that Data Compare produces, or to actually change the language on the server?
At the top of the sql script that data compare produces.
And then set it back to british at the bottom of the script / comments
Brian Donahue wrote:
For my clarification, is the workaround to put the text
SET LANGUAGE us_English
at the top of the SQL Script that Data Compare produces, or to actually change the language on...
If Data Compare is explicitly seeting the language during the compare, then this is the cause of the problem.
I am generating the scripts from data compare, but then pasting these scripts into our own rollout tool (which runs sqlcmd).
So the scripts are being created in us_english, but then when they are run against the target database they are being run using the language of british (which our db is set to use).
As a workaround I am now setting the language to us_english at the begining of the script, and then back again at the end.
I think it would make scense if there was an option to "Use the database language" or "Specify language". If a language is specified then it should also be included in the script output to ensure it runs correctly.
Thanks / comments
If Data Compare is explicitly seeting the language during the compare, then this is the cause of the problem.
I am generating the scripts from data compare, but then pasting these scripts into our ...
I have exactly the same problem.
I'm disapointed that the tool can't cope with non-US date formats. / comments
I have exactly the same problem.
I'm disapointed that the tool can't cope with non-US date formats.