Home > By category > Servers >Other Server Applications > Schema Compare



Schema Compare

  • Downloads: 
  • Views: 
  • Rating:

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 :
http://www.codertools.com/images/server_connect.jpg

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 :
http://www.codertools.com/images/main_image.jpg

Step 4: Create a Preliminary SQL Script to Synchronise the Right Database to be the same as the Left Database
NOTE: SCRIPT is for GUIDANCE ONLY - REVIEW AND TEST SCRIPT BEFORE USING - USE AT YOUR OWN RISK

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 :
http://www.codertools.com/images/synchronise.jpg

Free download from Shareware Connection - Database Comparison Tool for SQL Server 2005 .

Publisher: Independence Software LLP | License: Freeware | Price: 0.00
Version: 1.0 | Size: 706 KB | Platform: WinOther
Released Date: | Rating: 0 | Title: Schema Compare

Author Url: http://www.codertools.com
Program Info Url: http://www.codertools.com
Download Url: http://download.codertools.com/SchemaCompare_1_0_install.msi

Schema Compare keywords:
Schema Compare related downloads:

Professional Notepad - Professional Notepad is a powerful editor that allows you view and edit HTML, CSS, JavaScript, PHP, SQL, Delphi, C++ and other languages source code. It is a advanced tool supporting syntax highlighting, Code Templates, unlimited text size, etc.

Free Text into Speech - Free text into speech software converts words into audio format with natural speaking voices.

dbForge Schema Compare for Oracle - dbForge Schema Compare for Oracle is a tool for easy and quick schema comparison and synchronization of Oracle databases. Compares large databases with multiple schemas quickly. Generates comparison reports and SQL*Plus compatible sync scripts.

Free JavaScript Editor - Free JavaScript Editor (Ajax Editor), Validator and Debugger for beginners and professionals(Ajax tool). AJAX developers can use free javascript editor as Free Ajax Editor. First specialized Free JavaScript Editor (Ajax toolkit) allowing test ajax

dbForge Schema Compare for MySQL - dbForge Schema Compare for MySQL allows you to compare and synchronize structures of MySQL, MariaDB and Percona databases. This product is designed to help developers analyze database structure differences and transfer the changes to a required MySQL

Shareware Connection periodically updates pricing and software information of 'Schema Compare' from company source 'Independence Software LLP' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft,  Using 'Schema Compare' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of Schema Compare.

New Reviews

Backup Dwarf Home Edition - Making backups of data and media content has become extremely important for computer users nowadays. Owing to hardware failure, you may end up losing gigabytes of precious data. Besides, you may not want to leave sensitive data accessible to all ...

KeePass Password Safe - Using password becomes mandatory for performing various online operations, at both home and workplace. For accessing email accounts, shopping online, making banking transactions and similar tasks it is necessary to use user ids and passwords ...

CleanMyDrive - PC experts unanimously agree that using Macs tend to be a smoother and faster experience than running Windows based PCs but the Apple laptops and desktops also need maintenance and performance tweaking, occasionally. Regular web browsing, ...

Hekasoft Backup & Restore - There was a time a majority of Windows PC users stuck to Internet Explorer as it was the integrated web browsing app. After arrival and growth of Open Source rivals like Firefox and Chrome, the scenario has changed a lot. PC users are now spoilt ...

PhoXo - Even a few years back, it was mostly graphic design professionals or people involved in print media were seen using image editing applications. With digital camera prices nose-diving and mobile imaging reaching new heights, things have undergone ...

HDD Guardian - No matter how costly a desktop or laptop is, it is necessary to keep a tab on its hardware components. While you can spot signs and symptoms of hardware malfunction and impending failure in some instances, some mishaps may just strike you out of ...

HotShots - Screen capture software comes in handy in a number of situations, as it is. If you want to show some web content worth your interest to friends or prepare an interactive tutorial, such apps are useful. Needless to say, Windows inbuilt screen shot ...

Groovy Media Player - There is hardly any PC user who does not listen to music while working on PC or at leisure time. For media playback on Windows PC, there are so many apps. You can opt for default WMP that comes with the OS. However, there are several other third ...

Bitcasa - The way computing technology evolves is quite amazing. Even a few years back data backup was limited mostly to external hard drives and DVDs. However, the proliferation of high speed internet access and emergence of cloud storage services have ...

UltraMixer Free Edition - Sound Mixing and is a sought after profession and creating your own mix is considered to be pretty cool. With Sound Mixing profession, also known as DJing, comes the need of certain software programs which help hugely while in this profession. ...




New Downloads

SQL Data Sets

SQL Data Sets lets you save
the results of your database
queries in a single file
called a 'package’,
which can be ...

Navicat Lite for Oracle

Navicat for Oracle offers
powerful visual tools such as
Query Editor with syntax
highlight capability, SQL
Preview, SQL ...

Microsoft Exchange Server
Jetstress 2013 Tool

Use Jetstress to verify the
performance and stability of a
disk subsystem prior to
putting an Exchange server
into ...

KernSafe Free iSCSI Target

KernSafe iStorage Server is an
advanced and powerful,
full-featured software-only
iSCSI Target Server for
Microsoft ...

pycsw

pycsw is an OGC CSW server
implementation that is written
in Python.

MoVigo

MoVigo was created as an
accessible, easy-to-use,
lightweight and portable web
server.

Mongoose for Windows

Mongoose is easy to use web
server.

HTTP Bog

HTTP Bog is a slow HTTP
denial-of-service tool that
works similarly to other
attacks, but rather than
leveraging request ...

JumpBox for MindTouch Core
Enterprise Collaboration

MindTouch Core is an
enterprise-grade collaboration
platform that makes it easy to
collaborate on data that
resides in ...

BizTalk WCF Service
Publishing Wizard

This tool is complementary to
the BizTalk WCF Service
Publishing Wizard, which is
part of BizTalk Server 2006
R2.

ADS LogManager Viewer

The ADS LogManager Product
Family is a suite of tools
which helps you to keep track
of data changes in your
Advantage ...

Revolver Server Monitor

Revolver Server Monitor is an
intuitive application that can
be used to monitor all the
connected users to a certain
server.