Comparing code in different database versions

Does anyone know of something that can compare different versions of the same database to highlight the code changes?

It can compare different database, or templates or something. I just need something that can analyse a whole database and let me know what code has been introduced or modified.

Cheers,

Katherine

Subject: Comparing code in different database versions

A few techniques are open to you if you don’t want to go down the route of commercial products like Teamstudio’s Delta:

Export db design as DXL and perform a diff on the resulting files

Compare design notes programmatically using the NotesNoteCollection class

Eyeball / diff the changes between the two database synopsis reports

HTH

Subject: Try TeamStudios Delta product.

Subject: Comparing code in different database versions

Katherine,

One way I suppose you could accomplish this is to generate design synopses for each database in Designer via Other → Synopsis and then use a text editor like NoteTab Light, available free at www.notetab.com, and run its “Compare Files” utility.

Ken

Subject: use Lotusscript?

I think - though I haven’t tried it for real - that you can examine design notes using the NotesNoteCollection. This script is a starting point, you could see what fields are available for comparison.

Sub Initialize

Dim session As New NotesSession

Dim db As NotesDatabase

Dim nc As NotesNoteCollection

Dim doc As NotesDocument

Dim noteID As String

Dim i As Integer

Set db = session.CurrentDatabase

Set nc = db.CreateNoteCollection(False)

nc.SelectForms = True ’ or agents or whatever

Call nc.BuildCollection

noteID$ = nc.GetFirstNoteId

For i% = 1 To nc.Count

Set doc = db.GetDocumentByID(noteID$)

' get design info for comparison

noteID$ = nc.GetNextNoteId(noteID$)

Next i%

End Sub