|
 |
Red Gate SQL Compare
Published By:
SQL Compare is the industry-standard tool for comparing and synchronising SQL Server database schemas. It's used by over 150,000 developers, DBAs and test engineers worldwide because it's easy to use, it's fast, and it saves time. Whether you are working with live databases, database snapshots or object SQL scripts under source control, SQL Compare will help you compare and synchronise database changes quickly, simply and with zero errors.
|
Product Variants
Red Gate SQL Compare Pro
Variant
|
|
Manufacturer Part#
|
|
Our Part#
|
|
|
| Professional, Commercial, New Licence - ESD 1 User Win |
|
P49U1M0 |
|
203290 |
|
Quote
|
| Professional, Commercial, New Licence - ESD 5 Users Win |
|
P49U5M0 |
|
213458 |
|
Quote
|
| Professional, Commercial, New Licence - ESD 10 Users Win |
|
P49U10M0 |
|
240279 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (1-Year) - ESD 1 User Win |
|
P49U1M12 |
|
214507 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (1-Year) - ESD 5 Users Win |
|
P49U5M12 |
|
213460 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (1-Year) - ESD 10 Users Win |
|
P49U10M12 |
|
240280 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (2-Years) - ESD 1 User Win |
|
P49U1M24 |
|
240277 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (2-Years) - ESD 5 Users Win |
|
P49U5M24 |
|
240283 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (2-Years) - ESD 10 Users Win |
|
P49U10M24 |
|
240281 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (3-Years) - ESD 1 User Win |
|
P49U1M36 |
|
240278 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (3-Years) - ESD 5 Users Win |
|
P49U5M36 |
|
240284 |
|
Quote
|
| Professional, Commercial, New Licence with Maintenance (3-Years) - ESD 10 Users Win |
|
P49U10M36 |
|
240274 |
|
Quote
|
Red Gate SQL Compare Standard
Variant
|
|
Manufacturer Part#
|
|
Our Part#
|
|
|
| Commercial, New Licence - ESD 1 User Win |
|
P18U1M0 |
|
213759 |
|
Quote
|
| Commercial, New Licence - ESD 5 Users Win |
|
P18U5M0 |
|
213457 |
|
Quote
|
| Commercial, New Licence - ESD 10 Users Win |
|
P18U10M0 |
|
240271 |
|
Quote
|
| Commercial, New Licence with Maintenance (1-Year) - ESD 1 User Win |
|
P18U1M12 |
|
154193 |
|
Quote
|
| Commercial, New Licence with Maintenance (1-Year) - ESD 5 Users Win |
|
P18U5M12 |
|
143882 |
|
Quote
|
| Commercial, New Licence with Maintenance (1-Year) - ESD 10 Users Win |
|
P18U10M12 |
|
240272 |
|
Quote
|
| Commercial, New Licence with Maintenance (2-Years) - ESD 1 User Win |
|
P18U1M24 |
|
240269 |
|
Quote
|
| Commercial, New Licence with Maintenance (2-Years) - ESD 5 Users Win |
|
P18U5M24 |
|
240275 |
|
Quote
|
| Commercial, New Licence with Maintenance (2-Years) - ESD 10 Users Win |
|
P18U10M24 |
|
240273 |
|
Quote
|
| Commercial, New Licence with Maintenance (3-Years) - ESD 1 User Win |
|
P18U1M36 |
|
240270 |
|
Quote
|
| Commercial, New Licence with Maintenance (3-Years) - ESD 5 Users Win |
|
P18U5M36 |
|
240276 |
|
Quote
|
| Commercial, New Licence with Maintenance (3-Years) - ESD 10 Users Win |
|
P18U10M36 |
|
361040 |
|
Quote
|
Features
- Comparison and synchronisation of SQL 2000 and SQL Server 2005 database schemas, eliminating hours of tedious, error-prone manual work.
- Comparison and synchronisation of live databases, snapshots or SQL script files.
- Deploy a live database from a set of object SQL scripts.
- Integrate with your source control system with SQL Changeset.
- Generate synchronisation script so databases can be perfectly synchronised.
- Support for all schema objects, including, but not limited to, tables, stored procedures views, user-defined functions, XML schema collections, and CLR Assemblies.
- Quickly produces comparison results and synchronisation scripts.
- Dependency checking so objects are scripted in the correct order for updates. Database objects are scripted in the correct order even if SQL metadata (sysdepends) is broken.
- Provides warnings about anything you need to be aware of prior to running a SQL synchronisation script.
- Graphical comparison of differences in Microsoft SQL Server database schemas.
- Save scripts for use later.
- Save schema snapshots for audit and roll-back purposes.
- Generate reports in HTML or Excel for an audit trail of database changes.
- Offline comparison ability so you can compare disconnected databases.
Some of the procedures SQL Compare will automate for you:
- Comparing two databases or a database with SQL scripts
- Generating synchronisation scripts
- Taking database snapshots and comparing them - useful for audit trails
- Change histories, ideal for database versioning
- Executing 'right-first-time' database synchronisations
Editions
Standard Edition
Compares and synchronises SQL Server database schemas.
Pro Edition
Simpler automation and development with source control:
- Exports your database as set of script files.
- Compares/synchs with script files.
- SQL Changeset for integrated checkin/edit/checkout.
- Accesses command line interface.
System Req.
- Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003, Windows Server 2008
- SQL Server 2000, 2005, 2008, 2008 R2
- Microsoft .NET Framework 2.0 or later
- MDAC 2.8+
- 256 MB RAM
- 200 MB hard disk space
- Minimum screen resolution of 1024x768
- Runs on a user's PC (can also run on a server)
|
|