• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

XML comparison tools - nice requirement

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes Sir :-).

I thought someone posted a reply to my requirement :-(.
 
Paul Clapham
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic