Check your application schema for trouble spots!

Are you considering using something like Pro2 replication? Preparing for a Dump & Load? Look before you leap!

ProTop includes a utility that will examine your schema and report on things that really shouldn’t be part of anyone’s data dictionary (RECID fields, tables without a unique index, tables with NO index) and things that are just a pain in the neck (LOBs).  

Run PROTOP/util/schemachk.p manually against any database you are considering externalizing and prepare to address the issues reported ahead of time.