Page 1 of 1

DataCompare: SET LANGUAGE statement

Posted: Tue 19 Jan 2016 18:50
by tech123
I just downloaded trial versions of Schema and Data Compare. When running synchronize, it is outputting the following statements at the beginning of any scripts:

Code: Select all

SET LANGUAGE 'Russian'
SET DATEFORMAT ymd
My user interface is using English but any messages from the script are output in Russian characters. I am an English user. I've verified my Windows regional settings are correct (English), as well as the database default languages. I don't remember picking anything on installation. I don't see anywhere in the software to 'set' this. Is there a way to disable/set this properly?

Re: DataCompare: SET LANGUAGE statement

Posted: Wed 20 Jan 2016 13:17
by alexa
Could you please let us know what version of the SQL Server you are using?

Please also perform the following:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Generate a synchronization script for any record.
6. Open the generated *.log file with the latest date from the directory

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Data Compare for SQL Server\
.
7. Find the query looking similar to

Code: Select all

SELECT Alias from sys.syslanguages where lcid = <number>
8.Execute the found query in a new SQL document and provide us a result.

Additionally, please export the following registry branch and provide it to us:

Code: Select all

HKEY_CURRENT_USER\Control Panel\International
You can reply straight to our support system at supportATdevartDOTcom

Re: DataCompare: SET LANGUAGE statement

Posted: Mon 25 Jan 2016 01:59
by tech123
I sent an email to the support address. I will make a couple notes here.

The source database is on Azure. The following query:
alexa wrote: 7. Find the query looking similar to

Code: Select all

SELECT Alias from sys.syslanguages where lcid = <number>
fails as it is not allowed. Also assuming the output log is sequential, the SET LANGUAGE to Russian output seems to be generated before this query is even run.

I'll wait to hear from support. Thanks.

Re: DataCompare: SET LANGUAGE statement

Posted: Mon 25 Jan 2016 10:44
by alexa
We would like to let you know that dbForge Data Compare for SQL Server, v4.0.32, where the issue you reported is fixed, has been released and is available for downloading https://www.devart.com/dbforge/sql/data ... nload.html

Thank you for your help in improving dbForge Data Compare for SQL Server.