There is a tool in SQL 2005 that can be used to check any differences with tables called tablediff. Check if that statisfies your req. If not you can use third party utilities to do the same. check quest site the have lot of utilities for sql server.