SQL Power Software Forum

After running the Merge engine there is no screen or area, informing the user what the merge engine did.

It would be very useful to know what records were deleted, merged, or what happened to which records in what table.

Good point. We all know the "merge" engine is actually a "modify and delete" engine that carries out your commands. It's natural that you'd want a summary of exactly what it did, so you can panic if it deleted all your customer data.

We'll get right on this.

-Jonathan

We've looked at this, and we have some specific improvements in mind. However, the MatchMaker may already be providing more information than you realize!

If you run your merge with the message logging level set to DEBUG, you will see a log message for every deleted record and every modified record. This log also begins with a message that shows the order that the merge engine has planned to perform the merge in.

We'll make this information more readable, possibly promote some of the information from DEBUG to INFO, and finally we will print the summary you asked for at the end of the log.

Hope this helps.

-Jonathan

Thanks, I tried to sift through the log file, without much success.
It would be more useful for me if the information was easier to read.

Ok, we've added a summary of the merge engine's activity. This is logged at the end of the engine run at INFO level, so you will see it by default.

We are still working on clarifying the rest of the log output, but I can now say for certain that the log does contain all of the information you need. All you have to do is search for it. A decent strategy is to open the log file in a text editor and use its "Find..." and "Find Next" functions to look for the data that interests you.

Let me know how you like the summary table. It will be available in the upcoming nightly build (20080722).

-Jonathan