title: fastest way to differ two tables one in sql and one in access
body: <p>I am writing a table differ utility for checking differences between similar schema tables in access and sql server. all i want to know that what could be the fastest way of achieving it as i have a very large number of tables in both the databases.</p>
  
  <p>i am comparing two tables lets say tableX in both access and sql with same schema and same column definitions and constraints and it has different rows and tuples in tables i want to identify that difference and extract that difference</p>
  
  <p>Thanks 
  Steave</p>