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 .
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
Microsoft Application Virtualization Dashboard
Active Directory Auditing Reports
BroadWave Pro Streaming Audio Server
JiJi Active Directory Reports
Mac Trash Recovery
JiJi GPO Search
BigAnt IM Server
Active Directory Management Software
BlissRADIUS
WMS Log Analyzer Enterprise Edition
WMS Log Analyzer Standard Edition
Webcam 1-2-3 v
WMS Log Storage Standard Edition
Proxy Log Explorer Standard Edition
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.
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. ...