Publisher's Description
From Yes Software:
SQL Server Compare is an easy-to-use tool that compares 2 SQL Server database schemas and list differences. Compares tables, stored procedures, indexes, triggers, users, views and record counts. You can view or save SQL scripts of differing objects.
More Popular Database Software downloads
- Oracle Database 10g Express Edition
2,728 downloads
- MySQL Database Server
2,578 downloads
- Navicat Premium Essentials (Multiple Databases GUI)
1,401 downloads
- PL/SQL Developer
1,300 downloads
- Crystal Reports
1,126 downloads
-
All versions:
4.3 starsout of 6 votes
-
Current version:
4.3 starsout of 6 votes
-
My rating:
Write review
Results 1-6 of 6
-
"Nasty Error Message"
Version: SQL Server Compare 1.0
Pros
Small, lightweight
Cons
It ran, but when trying to compare it displayed an unmeaningful error message about a missing DLL
Poor quality -
"Amazing, and it's free!"
Version: SQL Server Compare 1.0
Pros
Compares tables, sp's, indexes, triggers, views, users...
Cons
Doesn't do data comparison beyond record count; no facility to align; misses 2005/8 specific attributes in comparison and creation.
Summary
This utility does most of what you need, but it's free. Differences are highlighted in sql, missing objects are scripted. You have to do the hard work to align the schemas, but hey - it's free! Did I mention it's free?
-
"Very impressive - significant timesaver for small dbs."
Version: SQL Server Compare 1.0
Pros
Successfully compared Tables, indexes, triggers, record counts, SPs, Users and Views, and highlighted the exact differences between my local copy and a production db - very impressive for a freeware product.
Cons
None.
-
"Nice app. for smaller DB's"
Version: SQL Server Compare 1.0
Summary
Saves me the time of running the scripts to perform the check.
-
"Wonderful!!!!"
Version: SQL Server Compare 1.0
Summary
I even test this with a huge database, it works fine. But the time factor is the only concern. Other than that, it goes well....
-
"Good little utility!"
Version: SQL Server Compare 1.0
Summary
This is a very good freeware app. Of course I wish it had more features such as the ability to compare two objects in two different databases without having to search the whole database. I give a lot of credit to the author as he has done me a great favor and given this app a wonderful start! I look forward to version 2.0