my dog learned polymorphism*
The moose likes XML and Related Technologies and the fly likes XML comparison tools - nice requirement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "XML comparison tools - nice requirement" Watch "XML comparison tools - nice requirement" New topic
Author

XML comparison tools - nice requirement

Murali Yeduvaka
Greenhorn

Joined: Aug 21, 2006
Posts: 7
Hi,

We have business rules stored in form of XML stored in database(IVS). The columns are of type CLOB. Once the development of Rules is over we will move them to another Database which is production like. Before moving we have to compare the XML data in those 2 databases merge differences.

I don't think any comparison tools like WinMerge will be useful as they perform text file comparison.
I m looking for nice GUI tools to fit in this requirement. Does anyone used any XML compare tools before ?? are there Java API ?

While browsing on the net i found the below 3
ExamXML from A7soft,
XMLSpy from Altova
DeltaXML.

What i am thinking is "Using a script (implemented in Java) Retrieves the XMLdata from both the databases, store them as XMLs and then invoke that tool with those 2 XMLs as input". User can merge them and save them. After that another Script(implemented in Java) will upload the saved files into the database.
Any good ideas will be appreciated .... :-). This is bit urgent.

Thanks in Advance,
Murali.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

"MuraliYAJ", welcome to JavaRanch.

We're friendly here, but we do require members to have valid display names.

Display names must be at least two words: your first name, a space, then your last name. Fictitious names are not allowed.

Please edit your profile and correct your display name since accounts with invalid display names will be deleted.
Murali Yeduvaka
Greenhorn

Joined: Aug 21, 2006
Posts: 7
Yes Sir :-).

I thought someone posted a reply to my requirement :-(.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

Originally posted by Murali Yeduvaka:
I thought someone posted a reply to my requirement :-(.
No, sorry. But thank you for your quick response.

I don't have any personal experience of XML-diff products. But from your description of your requirements, it sounds like it would be much preferable if the XML-diff product you chose would have a Java interface. Or at least a command-line interface. So perhaps you should include that idea when you evaluate those products.
Murali Yeduvaka
Greenhorn

Joined: Aug 21, 2006
Posts: 7
Right Paul. I thought i will build some scripts if they have any API.

But tools which have nice GUI are preferrable. Ex: tools like WinMerge, BeyondCompare.

I just wanted to confirm that Winmerge and BeyondCompare are Text-based comparison tools right? I mean they are not aware of XML tags right? or Can i use "Beyond Compare" for XML-comparison??

I am working on few tools and looks like "ExamXML" has good, readable interface when i used complex XMLs.

But i wanted to know how reliable that tool is. Did anyone use ExamXML??
Murali Yeduvaka
Greenhorn

Joined: Aug 21, 2006
Posts: 7
After evaluating few tools i found "DiffDog professional Edition from Altova" is a good tool.

Except retrieving XML data from database it has many good features.

Retrieving from Database is not a big task for automation.

Murali
Murali Yeduvaka
Greenhorn

Joined: Aug 21, 2006
Posts: 7
If you don't want to spent that much on "DiffDog from Altova, you can consider using "ExamXML from A7soft", it is also a good tool.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: XML comparison tools - nice requirement