Best Automation tool in comparing data between two table in dev and prod database

Hi,

Im a QA tester and would like to know list of best tools to automate the data comparison between two database (say dev and prod). Also would like to know the pros and cons of each tools. We are currently using Excel Macro and QTP.