• Eric M Russell (1/26/2016)


    Given a database with no defined foreign key constraints, analyzing schema information is essentially inferring relationships by static analysis. Another approach is looking at join operators within stored procedures or even cached sql execution plans.

    That's exactly what we had to do when moving a software package and database to a whole new environment and structure.