Comments
Sort by recent activity
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...
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 ...
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...
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?
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. ...
Issue resolved. Thank you. / comments
Issue resolved. Thank you.
I missed that step. I set neither session.options nor provider.options. SqlOptions is being evaluated to Default for both in my watch window.
I will make the change and let you know if that fixes it. / comments
I missed that step. I set neither session.options nor provider.options. SqlOptions is being evaluated to Default for both in my watch window.
I will make the change and let you know if that fixes...
I'm using vb.net so I assume I can do it like this:
Dim mappings As New TableMappings
mappings.Options.SqlOptions = SqlOptions.OutputComments Xor SqlOptions.OutputCommentHeader Xor SqlOptions.Default
Correct?
Thank you. / comments
I'm using vb.net so I assume I can do it like this:
Dim mappings As New TableMappings
mappings.Options.SqlOptions = SqlOptions.OutputComments Xor SqlOptions.OutputCommentHeader Xor SqlOptions.Defau...
I'm still getting comments in the text file. By the way, I added "UseTransactions" to the xor string because we also wanted to turn off that setting. So the line of code became:
mappings.Options.SqlOptions = SqlOptions.OutputComments Xor SqlOptions.UseTransactions Xor SqlOptions.OutputCommentHeader Xor SqlOptions.Default
This is equivalent to
mappings.Options.SqlOptions = SqlOptions.DisableKeys
because DisableKeys is the only default setting I'm not turning off. I confirmed in the watch window that my xor string is being evaluated to just "DisableKeys". But the program seems to be ignoring the SqlOptions altogether and inserting all the comments and transaction statements.
Any idea why the program is ignoring SqlOptions?
Thanks. / comments
I'm still getting comments in the text file. By the way, I added "UseTransactions" to the xor string because we also wanted to turn off that setting. So the line of code became:
mappings.Options....