Comparing the data in two databases is part of the core functionality of IDERA SQL Data Compare.
The databases you wish to compare (or tables within them) can be virtually anywhere – as long as you have access to them you can compare and synchronize them. Furthermore, the databases do not have to be of the same version or flavor – you can compare between any “flavors” of the SQL Server: Express, Developer, Standard, Enterprise.