Activity overview
Latest activity by mago
Dear David:
I try sql compare and get the same error in sql compare application. But when I check the option : case sensitive, I could do sql compare. (The resuilt is fail because there are too many dependancy issues)
But I'm not sure why sql data compare relates sql compare. I know the table schema which I do sql data compare are all the same.
If any information I could provide, please feel free to tell me.
Regards,
Mago / comments
Dear David:
I try sql compare and get the same error in sql compare application. But when I check the option : case sensitive, I could do sql compare. (The resuilt is fail because there are too man...
Hi, Brian:
You are right. The compatibility problem is not resolved even I change new XML format. Our server is installed as "Chinese_Taiwan_Stroke_Bin"(case-sensitive), the default is "Chinese_Taiwan_Stroke_CI_AI". I guess it may be the problem. Could you please confirm if it works uder the sql collation ? Thanks a lot.
Mago / comments
Hi, Brian:
You are right. The compatibility problem is not resolved even I change new XML format. Our server is installed as "Chinese_Taiwan_Stroke_Bin"(case-sensitive), the default is "Chinese_Tai...
Hi, Brian:
I listed my xml file as the following.
I didn't add <casesensitive /> in sql data compare 4.0, and it runs smoothly.
But upgrade to 5.0, it always shows error as I said.
We try to add <casesensitive /> in our xml, but it still didn't work.
[code]
<?xml version="1.0" ?>
<commandline>
<verbose />
<database1>TSR</database1>
<server1>server1</server1>
<username1>sa</username1>
<password1>xxx</password1>
<database2>VIP</database2>
<server2>server2</server2>
<username2>sa</username2>
<password2>xxx</password2>
<include objecttype="Table" matches="\[Block\]" />
<include objecttype="Table" matches="\[EbugComment\]" />
<include objecttype="Table" matches="\[EbugData\]" />
<include objecttype="Table" matches="\[EbugForm\]" />
<include objecttype="Table" matches="\[EbugStatus\]" />
<include objecttype="Table" matches="\[EbugUpload\]" />
<include objecttype="Table" matches="\[Field\]" />
<include objecttype="Table" matches="\[Item\]" />
<include objecttype="Table" matches="\[OEM\]" />
<include objecttype="Table" matches="\[Product\]" />
<include objecttype="Table" matches="\[Role\]" />
<include objecttype="Table" matches="\[Template\]" />
<include objecttype="Table" matches="\[VIPFilterField\]" />
<include objecttype="Table" matches="\[VIPFunction\]" />
<include objecttype="Table" matches="\[VIPUser\]" />
<include objecttype="Table" matches="\[VIPUserFunction\]" />
<include objecttype="Table" matches="\[VIPUserTemplate\]" />
<include objecttype="Table" matches="\[VIP_Module_Configuration\]" />
<include objecttype="Table" matches="\[VIP_Contact_Staff\]" />
<casesensitive />
<ignoreidentical />
<synchronize />
<force />
</commandline>
[code] / comments
Hi, Brian:
I listed my xml file as the following.
I didn't add <casesensitive /> in sql data compare 4.0, and it runs smoothly.
But upgrade to 5.0, it always shows error as I said.
We try to add <c...
Error: A duplicate object name has been found
Dears :
I got the error messsage:
Error: A duplicate object name has been found. This may occur if the SQL Server
that you are registering is case sensitive but the case sensitive option is not
se...
How to specifies which columns are to be synced in XML file
Dears :
Sorry to ask a stupid question. How to specifies which columns are to be synced in XML file if I would like to use XML to specify command line arguments.
I didn't find out the sample in hel...
Is it possible to run faster when data compare?
Dears:
Many thanks for great product to make us convenient to sync database.
But I have a question about sync performance.
I'm not sure if it's limit about data sync.
We have two database sync, the...
Dear Brian:
Yes. I found the parameter in sql data compare. [image]
Sorry again and again.
Thanks a lot.
Regards,
Mago[/b] / comments
Dear Brian:
Yes. I found the parameter in sql data compare.
Sorry again and again.
Thanks a lot.
Regards,
Mago[/b]
Hi, Brian:
Could you please tell me the detail about sql data compare operations ?
Does it only set one transaction for whole sync operation or for one updated sql ? It's different.
If only one transaction for whole sync operation, tables would be locked a long time after data sync finished. I suggest to have setting to disable it inside sql data compare(like sql compare).
If it just locked table as SQL Server behaviour for insert one row at that time, it cannot explain why table is locked so long.
Many thanks your quick response. :-)
Regards,
Jessy / comments
Hi, Brian:
Could you please tell me the detail about sql data compare operations ?
Does it only set one transaction for whole sync operation or for one updated sql ? It's different.
If only one tra...
Hi, Brian:
Sorry. I need to refine my question. Maybe the reason is not transation lock when sql data compare runs.
My question is :
Why a simple sql query times out when sql data compare runs.
When our sql times out, I try to check server's loading. The sql data compare always runs at that time. So we think sql data compare results in table lock that we couldn't get data at the time by our sql. (Our sql doesn't include any transaction)
Could you please tell us more about sql data compare's operation ?
Does sql data compare lock table when updating data ? And what do we do to avoid that ? Thanks a lot. :-)
Regards,
Mago / comments
Hi, Brian:
Sorry. I need to refine my question. Maybe the reason is not transation lock when sql data compare runs.
My question is :
Why a simple sql query times out when sql data compare runs.
Whe...
HI, brian donahue:
The simular question is :
What's sql data compare's Isolation Level
When sql data compare runs, we cannot select a row from the database.
If sql data compare allows "READ UNCOMMITTED", I guess our selection is operatable. For our case, we must to wait for sql data compare complete, then we could run our select sql. It seems a little unreasonable.
Regards,
Mago / comments
HI, brian donahue:
The simular question is :
What's sql data compare's Isolation Level
When sql data compare runs, we cannot select a row from the database.
If sql data compare allows "READ UNCOMM...