Menu
▾
▴
Re: [Exist-open] comparing two databases - do you have a solution?
|
From: Palmer, E. <ep...@ri...> - 2013-01-31 20:30:46
|
Thanks This gives us some options. From: Dan McCreary <dan...@gm...<mailto:dan...@gm...>> Reply-To: "da...@da...<mailto:da...@da...>" <da...@da...<mailto:da...@da...>> Date: Thursday, January 31, 2013 3:25 PM To: Eric Palmer <ep...@ri...<mailto:ep...@ri...>> Cc: "exi...@li...<mailto:exi...@li...>" <exi...@li...<mailto:exi...@li...>> Subject: Re: [Exist-open] comparing two databases - do you have a solution? Hi Eric, I am not sure if you want to do diffs of the data within eXist or on a file system. If it is doing diffs on flat files in file system one way is to use some type of "regex" script to remove all the time stamps before you do diffs. This can be done with the Apache Ant "replace" function that uses regular expressions for the timestamps. You can then use oXygen's directory diff tools if you have them. Here is the Apache Replace with Regular Expression tool: http://ant.apache.org/manual/Tasks/replaceregexp.html If you are doing diffs within running eXist databases you can look here: http://en.wikibooks.org/wiki/XQuery/Compare_with_XQuery I wrote some of these, with the help of Chris Wallace, to do comparisons of two remote eXist sites to see what data has changed. Note that the example uses just XML files to see what is out of sync, but the merge() function should be very similar. It would be nice to have a single EXPath module that would use hash trees to do fast comparison of collections. - Dan On Thu, Jan 31, 2013 at 9:18 AM, Palmer, Eric <ep...@ri...<mailto:ep...@ri...>> wrote: 1.4.2 stable but going to 2.0 soon We have two production databases and a backup has shown that the backup files are slightly different from each other in terms of size. Doing a linux diff produces a lot of noise because some time stamps can be different. I'm wondering if anyone has some sort of diff tool for walking collections and documents and reporting out differences. Eric Palmer U of Richmond ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ Exist-open mailing list Exi...@li...<mailto:Exi...@li...> https://lists.sourceforge.net/lists/listinfo/exist-open -- Dan McCreary NoSQL Evangelist office: (952) 931-9198 cell: (612) 986-1552 |