Source system pre-integration analysis

Total article views: 376 | Views in the last 30 days: 7

 Rate this |   Join the discussion |  Briefcase

Initial analysis of a new source system can be quite time consuming to manually examine tables and columns to determine which even have worthwhile values in the first place. Running this script against the current database will generate useful information for all the columns of all the tables. Details include data types with varchar lengths, row counts, minimum and maximum values, and a count of the nulls and the distincts. It does take a long time to run but my (your) time can be spent more productively doing something else while this examines all the columns. Please see inline comments for additional thoughts.

Total article views: 376 | Views in the last 30 days: 7