[firebird-support] Checking if scripts ran correctly

2011-12-06 Thread Eduardo A
Just found a remote database that did not have a field in a table which had been added some 4 or so scripts ago. That makes me suspect of all script updates. What is the fastest and most reliable way to check all my deployed databases (say 200 of them) to see if all the scripts have run correc

Re: [firebird-support] Checking if scripts ran correctly

2011-12-06 Thread Jesus Garcia
> > Just found a remote database that did not have a field in a table which > had been added some 4 or so scripts ago. That makes me suspect of all > script updates. > > What is the fastest and most reliable way to check all my deployed > databases (say 200 of them) to see if all the scripts have

Re: [firebird-support] Checking if scripts ran correctly

2011-12-06 Thread Alexey Kovyazin
Hello Eduardo, Hope all your databases run Ok now :) Use isql -x to extract metadata and then compare their size and/or contents with some text compare tool. If you need detailed comparison and then create scripts to align master and target structures, take a look at DB VCL suite from clevercom