Comments
Sort by recent activity
Dears:
It happens again. It staill couldn't work after upgrade. [image]
Could you please give resolved way about that ?
For us, the table is important and must be synced.
Thanks a lot.
Regards,
Mago
Brian Donahue wrote:
Hi Mago,
Updating may help, but as far as I know there is no fix for the root cause of this problem. This happens if someone has inserted certain binary values into an nvarchar or nchar column that cannot be resolved as Unicode because of conflicting information about continuation character data. (To make a long story short!)
/ comments
Dears:
It happens again. It staill couldn't work after upgrade.
Could you please give resolved way about that ?
For us, the table is important and must be synced.
Thanks a lot.
Regards,
Mago
Bria...
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 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...
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:
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...
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, Brain:
Thanks for your reply.
Do you mean we have two same object name, but the two object have different owner ? The possible factor is that we use a common table name : User.
In fact, I'm not sure why there is no such error in 4.X, but happens in 5.X to sync same databases. When we use sql backup 4.X, we have no error message. After upgrading to 5.X, it always told me that error.
Please adviced. Thanks.
Regards,
Mago / comments
Hi, Brain:
Thanks for your reply.
Do you mean we have two same object name, but the two object have different owner ? The possible factor is that we use a common table name : User.
In fact, I'm not...
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...
Dear Brian:
Sorry to bother you.
I find out the answer in previous posts. http://www.red-gate.com/MessageBoard/vi ... hlight=xml
Thanks again.
Mago / comments
Dear Brian:
Sorry to bother you.
I find out the answer in previous posts.http://www.red-gate.com/MessageBoard/vi ... hlight=xml
Thanks again.
Mago