Activity overview
Latest activity by david.duffett
Hi Chris
Rolling back the data files for this particular table reproduces the problem - all tables UP UNTIL this one go through fine, then it stalls with the ASYNC_NETWORK_IO wait until I guess SQL Data Compare times out.
I've enabled logging and will email you the log file - hopefully you'll be able to find the problem and fix in case it happens to anyone else in the future.
David / comments
Hi Chris
Rolling back the data files for this particular table reproduces the problem - all tables UP UNTIL this one go through fine, then it stalls with the ASYNC_NETWORK_IO wait until I guess SQL...
Deleting the _Data.sql and _Meta.sql files for the table in question and re-generating them manually solved the issue.
Any thoughts on how they could have become corrupt? They are only ever updated by SQL Data Compare Pro. / comments
Deleting the _Data.sql and _Meta.sql files for the table in question and re-generating them manually solved the issue.
Any thoughts on how they could have become corrupt? They are only ever update...
ASYNC_NETWORK_IO wait causing data compare to fail
We run a continuous integration process using SQL Data Compare Pro. This morning our build tasks started to fail when comparing one particular table (the only one with a data difference).
Looking ...
Everything fine thanks. / comments
Everything fine thanks.
Constraint names when rebuilding tables
(Apologies - this doesn't seem to be a problem as constraints are deleted further up the script)
This problem (SDC-1152) has been fixed in the latest cumulative fix. I just downloaded and tested and it now ignores a letter case only change unless you specify case-sensitivity in the options. / comments
This problem (SDC-1152) has been fixed in the latest cumulative fix. I just downloaded and tested and it now ignores a letter case only change unless you specify case-sensitivity in the options.
Is there any update on this? At the moment I'm having to manually add and remove simple records from all our dev and test machines - can't fathom why it won't simply insert or delete records on certain tables due to this error. / comments
Is there any update on this? At the moment I'm having to manually add and remove simple records from all our dev and test machines - can't fathom why it won't simply insert or delete records on ce...
Problems with case sensitivity varchar comparisons
For a while now the scripts that have been generated comparing data between my dev and test databases have always included the following:
-- Drop constraints from [dbo].[tbTask_Class_Setting]
ALTER...
I agree - the patch has not solved this problem. I've now had it occur with a much simpler comparison - just one record needed to be added to a table with a non-identity primary key.
Error appears both in command line and application when trying to update scripts folder, exactly as edockx has described. / comments
I agree - the patch has not solved this problem. I've now had it occur with a much simpler comparison - just one record needed to be added to a table with a non-identity primary key.
Error appears...
Auto-update for Red Gate applications
I couldn't find a general "Red Gate" forum here so I'm posting to the SQL Compare one.
I really like the fact that you guys frequently release patches and new versions of your software, however I d...