Tool to compare 2 servers

Marc Marc 1, 1 1 gold badge 18 18 silver badges 31 31 bronze badges. Thank you for the great link to go with the answer. Direct Link: iis. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta.

Answered by:. Archived Forums. SQL Server Tools. For discussions on features exposed through tools, please post to the directly-related forum 0 5. Sign in to vote. Hi all, I need a need a tool which can compare objects tables, primary keys, etc in two databases meant to be equal in different servers and give a report stating all the differences found. The source and target of the comparison can be any combination of connected database, SQL Server database project or snapshot or.

The results of the comparison appear as a set of actions that must be taken with the target to make it the same as the source. Once the comparison is complete you can update the target directly if the target is a project or a database or generate an update script that has the same effect.

The differences between source and target appear in a grid for easy review. You can drill into and review each difference in the results grid or in script form. You can then selectively exclude specific differences.

You can also set options that control the scope of the comparison and aspects of the update. Then you can save the comparison so that you can easily repeat the same comparison later or use it as the starting point for new comparison.

If a project is specified as the target for comparison, the maximum supported path length excluding drive letter, colon and leading backslash for the project is characters.

If your project path exceeds characters, you will still be able to compare its schema with a database or another project. However, you will not be able to update its schema. The following procedures utilize entities created in previous procedures in the Connected Database Development and Project-Oriented Offline Database Development sections.

Two drop-down menus with a green arrow in between them appear just below the Schema Compare window toolbar. These menus allow you to select database definitions for your comparison source and target. Notice that if you opened the Schema Compare window by right clicking the project name, the source schema is already populated and you can proceed to step 4.

Select the Project radio button, and then select the TradeDev database project you have created in the previous procedure. In the Schema section, click the Database radio button, then click the New Connection button.

In the Connection Properties dialog box, enter the server name where the TradeDev database resides and make sure that correct authentication credentials are provided. You can also click the Options button in the Schema Compare Window toolbar to specify which objects are compared, what types of differences are ignored, and other settings. If you have SQL server data tool installed with Visual Studio, you can easily compare the two database schema using it.

The source and target of the comparison can be any combination of connected database, SQL Server database project or snapshot or. In the next screen, you need to select "Source" and "Destination" schema, which we want to compare. This is another great tool to compare database schema, but it is not free, yes, you can try it for free. A powerful, fast, and easy-to-use data comparison tool.

This tool is free to try.