>
> 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?
>

I use one script component developed by me that uses IBX. What i do is
save a log file with the exceptions raised when runing the script. After
running the scripts, i see that log files. It is not complicated to send
the scripts by email, for example, after running the scripts.

I think is not necessary a commercial component, just logging the
exceptions when running the scripts and analyze them.

Jesus


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