Comments
Sort by recent activity
Dears :
I found there is "SQL Backup" software in your product list. [image]
How about its speed ?
We have a database its data backup size is up to 1.7G.
We want to sync database every hour.
Could we use this product to replace SQL Data Compare ?
Thanks for your info in advanced. [image]
Regards,
Mago / comments
Dears :
I found there is "SQL Backup" software in your product list.
How about its speed ?
We have a database its data backup size is up to 1.7G.
We want to sync database every hour.
Could we use...
Dears:
I know you mentioned the script to point out the data in previous post.
So I tried to execute it.
DECLARE @table nvarchar(80), @column nvarchar(80), @qry nvarchar(255)
DECLARE cColumns CURSOR FOR
select o.[name] AS , c.name AS [Column]
from syscolumns c INNER JOIN sysobjects o ON c.[id]=o.[id]
where c.xtype IN
(select xtype from systypes where name IN ('nchar', 'ntext', 'nvarchar')) AND o.xtype='U'
OPEN cColumns
FETCH NEXT FROM cColumns INTO @table, @column @FETCH_STATUS=0
BEGIN
SELECT @qry='SELECT FROM WHERE CAST( AS BINARY) BETWEEN 0xdddddddd AND 0xffff'
exec sp_executesql @qry
FETCH NEXT FROM cColumns INTO @table, @column
END
CLOSE cColumns
DEALLOCATE cColumns
GO
After execution this sql, it point out more than 10 thounds records may have problems in a specific table.
Even if we know the offending rows, how could we do ? we still couldn't correct or delete it because it's for user input, not us.
Besides that, when I execute data compare using our software, it shows error from System.Text.UTF8Encoding.GetByteCount.
But if we write a .Net program to read db and parse it directly with System.Text.UTF8Encoding.GetByteCount, it didn't show any error.
It's just our testing. I hope this could provide some info to you. [image]
Brian Donahue wrote:
Hi mago,
I suspected the update wouldn't help. SQL Server will happily allow you to stuff binary data into an nvarchar field. When Data Compare sees the column type is nvarchar, it knows to resolve the data to Unicode for displaying in the grid. If the type converter encounters byta values between 0x7FFF and 0xFFFF, then it can't be converted to Unicode.
Maybe if you post up the table schema, I can construct a query that will point out the offending row(s) of data.
/ comments
Dears:
I know you mentioned the script to point out the data in previous post.
So I tried to execute it.
DECLARE @table nvarchar(80), @column nvarchar(80), @qry nvarchar(255)
DECLARE cColumns CURSO...
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...