>Hi,
>Is there a utility to check the sync of the DBC after doing a structural update. i.e. at a remote site.
>The reason being we recently completed Version upgrade of our clients, and 2 out of 500 sites didn't update 1 of 3 changes to an existing view, and no errors were reported during the update.
I don't have anything ready, to upload to the download section.
However, I recommend that you have an empty copy of the database (official structure, zero records in all tables). Then, do an APPEND FROM from the client database.
Thus, you will have all views, all stored procedures, and all table structures, since they are in the new structure.
Additional considerations:
1) For RI, you have to copy parent tables before child tables. Obtain information with ADBOBJECTS("RELATION").
2) If you manage to detect that the table structure is identical, you can do a file-level copy for the DBF and related tables. This is much faster than copying with APPEND FROM.
3) It also helps speed things up (by a factor of 10, perhaps) if you temporarily disable RI. Third-party RI generators, such as TaxRI, can help you with this.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)