Interesting issue with my comparisons

[fmeads]

Wrote a small app to generate differences between our stagging and production databases. When we tested it we found that object which existed in both systems but were different were not included in the generated script. Does anyone have any insights? Below is the code I'm using:

Differences sdiff = db1.CompareWith(db2, Options.Default);
Work wrk = new Work();
wrk.BuildFromDifferences(sdiff,Options.Default,true);
StreamWriter sw = new StreamWriter(FilePath);
ExecutionBlock blk = wrk.ExecutionBlock;
sw.Write(blk);
sw.Close();

[Brian Donahue]

Hi Frank,

It's hard to say from the code fragment what the problem could be. I'd wager that it happens earlier in the program. Did you start with the Toolkit example project as a baseline to work from? In particular there is a loop where all difference objects have the selected property set to true. If this isn't done, then objects may not appear in the synchronization script. That's just a guess. The only way to work out why the result would not turn out as predicted would be to have all of your code and databases because this code fragment is not enough to go on.

Thanks!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521