Activity overview
Latest activity by RBohannon
API for SQL Data Compare 6.0.
Yes on all three dispose statements. They execute at the end of the procedure in the Finally block.
FYI, I'm comparing two SQL 2005 database backups.
Also the problem is intermittent. It doesn't seem to be happening now but I didn't change anything. It happened several times in a row at one store location but the next day when the program ran it didn't happen. I just want to be able to prevent it from happening again.
The machine reboots every night. / comments
API for SQL Data Compare 6.0.
Yes on all three dispose statements. They execute at the end of the procedure in the Finally block.
FYI, I'm comparing two SQL 2005 database backups.
Also the problem...
Error "Item has already been added. Key in dictionary:..."
We are using SQL Data Compare 6.0 and the .NET 2.0 framework. I recently added code to our program to clean out the C:\WINDOWS\Temp\RedGate folder daily because the folder was getting unmanageably...
I don't have copies of backups that exhibit the problem yet. Our clients don't typically notice the issue until days after it happens (after the backups have been discarded). I've been trying to get representative backups. If I do, I'll let you know. Thanks for your help. / comments
I don't have copies of backups that exhibit the problem yet. Our clients don't typically notice the issue until days after it happens (after the backups have been discarded). I've been trying to ...
To continue with your example, what happens with the third backup? Won't it show the changes that were made during the second backup? Won't it show the changes between the first and third backup? / comments
To continue with your example, what happens with the third backup? Won't it show the changes that were made during the second backup? Won't it show the changes between the first and third backup?
I don't think that could be it because if a user created the record during the first backup then it would be missing in the first backup but present in the second and therefore would appear as a change in the RedGate comparison and consequently appear as in INSERT statement in the change script. / comments
I don't think that could be it because if a user created the record during the first backup then it would be missing in the first backup but present in the second and therefore would appear as a ch...
We are comparing two backups. The backups were both made from the same database (at different times). So the keys are in the same order.
The tables do map because we receive 99% of the changes. It's just occasionally a change is not reported.
Thanks. / comments
We are comparing two backups. The backups were both made from the same database (at different times). So the keys are in the same order.
The tables do map because we receive 99% of the changes. ...
some records are not getting synched
We are using the SDC 6.0 programmatically to compare yesterday's backup to today's backup and produce a SQL script of the changes at the store. The SQL script is later executed on a remote server ...
Error when calling ComparisonSession.CompareDatabases
When I call ComparisonSession.CompareDatabases while comparing two database backups, I get the following error:
"No matching index was found for table Employee_Fingerprint"
Do all the tables have t...
Backup Comparison Performance
We are currently running SQL Data Compare 5. We are interested in upgrading to SDC 6 in order to get the backup compare functionality.
Currently our application creates a backup of the production ...
Issue resolved. Thank you. / comments
Issue resolved. Thank you.