Hi all. Anyone have some cool queries that I could use to determine if what should be identical tables and indexes do indeed match on two systems? I have a QA and a production system that should always be in synch, but I have been finding indexes here and there that developers have created on the QA box but forgotten to duplicate on the production box.
Just wondering if there is a shortcut versus dbschema'ing everything and eyeballing.
Just wondering if there is a shortcut versus dbschema'ing everything and eyeballing.