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.