About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 7 years ago
  • Total downloads: 173
  • Price: Free |
  • Operating system: Win All
  • Publisher: Independence Software LLP
See full specifications

windows default iconSchema Compare Publisher's description

Database Comparison Tool for SQL Server 2005 .

Database Comparison Tool for SQL Server 2005

Key Features:
Key selling point Compare database on the same or different servers
Key selling point Display sql object differences side-by-side
Key selling point Export difference report in html
Key selling point Create SQL scripts to help synchronise your databases

Schema Compare is a database tool that enables the user to compare two databases.

The program displays a list of all objects in each database and for each object specifies:

* If it exists in the left database only
* If it exists in the right database only
* If it exists in both and is identical
* If it exists in both and id different

Side-by-side Comparison - For database objects that are different the program will display a side by side comparison of the database object sql and highlight the differences.

Export - Create a report of the differences in html, and xml.

Synchronise - Create a preliminary script you can use as basis to synchronise the databases. NOTE - SCRIPT IS FOR GUIDANCE ONLY. USE AT YOUR OWN RISK.

Step 1: Connect to SQL Servers to Perform a Comparison

1. Select New from the File menu, or press the New Comparison toolbar button to display the connection dialog.
2. Enter the left database server name. This would be the name of the server the database is on.
3. Select from the Authentication selection box whether you want to use an NT Account or Sql Server user account.

See picture below :

Step 3: Using the Comparison View

To make the list smaller you can filter(hide) database objects by selecting the buttons above the grid. There are buttons to filter(hide) based on difference - left only, right only, equal, and different. And buttons to hide based on database object type.

An example would be to press the LEFT ONLY button to remove all objects from the grid that exist in the left database only.

To see a side-by-side comparison of a database object you are interested in, select the object name from the grid and the side-by-side comparison window at the bottom of the screen will update to show the selected object differences.

At the bottom left of the screen, to the left of the side-by-side comparison, is a quick view/navigation map of the compared database objects. Use it to and quickly spot the location of any differences, and to scroll the side-by-side comparison using your mouse.

See picture below :

Step 4: Create a Preliminary SQL Script to Synchronise the Right Database to be the same as the Left Database

On the toolbar menu press the Synchronise button and a window will open displaying the SQL code you can use as a basis to synchronise your database.

See picture below :

System Requirements:

No special requirements.
Program Release Status:
Program Install Support: Install and Uninstal

Schema Compare Tags:

Click on a tag to find related softwares

Is Schema Compare your software?

Manage your software

Most Popular

windows default icon Apache Tomcat 7.0.41
Apache Tomcat is an open source software implementation of the Java Servlet and JavaServer Pages technologies.... Read more
windows default icon WampServer 2.4
WampServer is a Windows web development environment.
windows default icon PS3 Media Server 1.81.0
PS3 Media Server is a DLNA compliant Upnp Media Server for the PS3, written in Java, with the purpose ... Read more
windows default icon TwonkyMedia Server 7.0.7
TwonkyServer makes it possible for your devices to retrieve your media files from wherever they're stored... Read more
windows default icon AnjLab.SqlProfiler 1.1.1423.75
The express edition of Microsoft SQL Server 2005/2008 is free.

Related Category

» FTP Servers (61)
» Mail Servers (122)
» News Servers (5)
» Web Servers (126)