Comparison based on data can be done automatically using third-party tools, which come at a price. Alternatively, you can write comparative SQL scripts that show you differences, but that is much more time consuming and less reusable.