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 clevercomponents.com

Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)

> 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
> correctly and applied the changes, or created triggers and procedures,
> contained in previously run scripts?
>
> Do I need a commercial product that can help? Or do I just have to
> "visit" each location and check the database structures manually?
>
> Thanks!
>
> -Eduardo
>
>

[Non-text portions of this message have been removed]