Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity?
"Validate" won't help: we had databases that were broken but "validate" always told us that everything is o.k. :-(
I had the idea to simple read every record in every table (first "select count(*) from...", second "select * from ...") Number of readed records must be same as the number of records reported by the "count(*)". - This works ok (I can report errors) - but I have found a database that will "hang" on the "Count(*)" (seems to loop forever, CPU-Usage 100% for >20Min (than i stopped it)
Any other ideas?