To use SQL Schema Compare to start a comparison between two databases, click Compare Databases on the Home tab of the ribbon. The SQL Server Database Selection dialog window appears and allows you to choose the server(s) where the databases you wish to compare reside as well as the databases themselves.
From this window, you can also access the Comparison Options that will be applied during the comparison.
Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >