I am looking for a tool that allows me to compare two SQL Server databases, see the differences, and move the changes from one database to another. In simpler terms, I want a tool exactly like the Schema Compare tool from Visual Studio, but without forcing me to have the Premium or Ultimate edition of VS.
Here are the requirements:
- Compatible with SQL Server 2008 or later databases
- Must compare both structure and data
- For Windows