Need to compare two databases

  • Today I need to compare a development application with a template, exactly where I’ve always relied on TS Delta in the past. But the entire v26 TS suite is useless for XPages - in essence it completely ignores them. DDE’s “Local History” only works within a database, and in the development app every single design element claims there is no local history, even CSS. Lastly, this particular app has to run XPages and R6.5.4 Notes, at least initially. Since the legacy elements were all developed using R6.5.4, I can build them all with that Designer version, and it actually works. (KUDOS to Lotus here!) BUT doing that sets the modification date to the instant “Rebuild All LotusScript” touched it, even XPage design, so it’s impossible to manually wade through the hundreds upon hundreds upon hundreds of design elements and compare their modification time stamps.

  • Is there some way to do what TS Delta used to do? Compare two databases and filter out the jillions of useless changes, while showing the changes that matter? That works with all aspects of R8.5.1?

Thanks for your time…

Subject: Response from Teamstudio employee

We realize we haven’t been able to get full XPage support into our tools as quickly as our customers wanted. We are working on some major enhancements for our next release that will greatly improve support for XPages. The release is scheduled for the end of September. Although development is still going on, we can get you an early copy of Delta that may help you with your current project. Please contact Scott Johnsen, our VP of Product Management. He can be reached at scott_johnsen@teamstudio.com.

Subject: Response from a TeamStudio fan…

  • There isn’t any XPages support in Delta or Analyzer, that I have been able to determine. Well there is - it shows me hex bytes of a binary diff on the compiled .class files in Delta. This is an apocryphal letdown for someone who’s spent so many years talking up the TS suite en toto, which has set quite a high bar with the “it just works” and “must-have designer companion” concepts. It would have been significantly better if TS said, up front and explicitly, that XPages are not supported in v26, in order to properly set expectation. Then we’d know to skip that until v27, when they’re supposed to be included, except now it’s “greatly improved XPage support”. This makes me fear what “greatly improved” is over “essentially nothing”.

  • This is sort of like Lotus failing to point out up front and explicitly that legacy code of more than trivial complexity is not supported in XPages, even today. These are more than a little disturbing, as trends, and if I were either organization I’d consider it a top priority to prove beyond a shadow of a doubt that they are not trends.

But I’ll contact Scott and we’ll see what happens. If it’s back to working like it always has I’ll be more happy to point that out, than if it doesn’t…

Subject: this is worth a try…

it may not be exactly what you want, but it is a start.

Local history won’t work across sessions, etc, because of our virtual file system. BUT, you can use one of the eclipse navigators to help out here. So first, do a Window/Show Eclipse Views/Other… to bring up this dialog, and search for Navigator:

this will open up the navigator view, which allows multi-selection.

You can then select just the db entry of each of the two dbs (control click, etc) - to give this:

then right click on one of the selected dbs, and say compare with/each other.

that gives you a window in the editor pane that looks like this…

There is an entry above for every unique file, and then double clicking on each will show the differences in that file. Now because this is a dxl compare for non-file type things, you may still get more differences than you want, but maybe this will help a bit.

Subject: Thanks Maureen!

  • Sorry I didn’t check for a response sooner! I’ll try this tomorrow just to see if it fits the bill…