Does anyone know if such a product exists that
a) You give it two SQL tables/views. One source, one destination
b) You give it all the SQL queries that have been run from start to finish, ie. query1, query2, query3
and then you can press map and it comes up with some graphical representation of the links & what steps it went through.
I am trying to reverse engineer 2.5years of work out of an access db, with a macro pointing to dozens of queries and it is frankly doing my head in. Surely I dont have to do this by hand. SURELY!!!!
a) You give it two SQL tables/views. One source, one destination
b) You give it all the SQL queries that have been run from start to finish, ie. query1, query2, query3
and then you can press map and it comes up with some graphical representation of the links & what steps it went through.
I am trying to reverse engineer 2.5years of work out of an access db, with a macro pointing to dozens of queries and it is frankly doing my head in. Surely I dont have to do this by hand. SURELY!!!!
Comment