Hi All,
I'm supporting a project that has 6000ish DB objects and many of the object names have system generated tables / objects (i.e. table names which have '$' in them).
Is there a way to exclude system generated objects when comparing schemas? I know you can choose which objects you want to include using a prefix (i.e. TMP, TAD etc) but these schemas do not have standard table naming practices so they are all over the place.
Any way to tackle this? I'd like to make this an automated report going forward so we can compare schemas on a regular basis to look for "real" differences.
Thanks,
Dan