This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

XML comparison tools - nice requirement

 
Murali Yeduvaka
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20750
30
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes Sir :-).

I thought someone posted a reply to my requirement :-(.
 
Paul Clapham
Sheriff
Pie
Posts: 20750
30
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic