SQL Comparison Bundle - Summary

by Red Gate Software - Product Type: Application

Summary

SQL Comparison Bundle by Red Gate Software

URLs: red-gate-sql-comparison-bundle, red gate sql comparison bundle, redgatesqlcomparisonbundle, red-gate, red gate, redgate

Compare, synchronize and package SQL database schemas and contents and track database and cross-database object dependencies. SQL Comparison Bundle includes SQL Compare, a tool for comparing and synchronizing SQL Server database structures, used by over 150,000 database administrators, developers and testers. SQL Compare automates the process of distributing database changes made on a local database to testing, staging or live databases on remote servers. SQL Data Compare, used when the data between two databases has got out of synch, and saves huge amounts of tedious work in synchronizing them. Also used as a tool for QA, documentation and verification. SQL Packager enables you to package the structure and contents of a Microsoft SQL Server database or database upgrade into a .NET executable file or a C# project, so that installing a database is much simpler. You can use it to package the database structure, data, or both, for installation or deployment. SQL Dependency Tracker allows you to dynamically explore all your database object dependencies, using a range of graphical layouts. You can analyze large Microsoft SQL 2000, 2005 and 2008 databases and produce an easy-to-read dependency diagram for thorough pre-impact analysis of all database changes.

SQL Comparison Bundle includes:

SQL Compare Standard Edition

SQL Data Compare Standard Edition

SQL Packager

SQL Dependency Tracker

SQL Compare

SQL Compare compares and synchronizes SQL Server database schemas.

Automate database comparisons

Synchronize your databases

Work with SQL scripts, snapshots, backups or live databases

Save hours of tedious work and eliminate manual scripting errors

Full support for SQL Server 2008

SQL Compare is an industry-standard tool for comparing and synchronizing SQL Server database schemas. It is used by over 150,000 developers, DBAs and test engineers worldwide because it is easy to use, it is fast, and it saves time. Whether you are working with live databases, database snapshots, object SQL scripts under source control or an earlier backup, SQL Compare will help you compare and synchronize database changes quickly, simply and with zero errors.

Read the whitepaper on database development in the Evals & Downloads section and discover how SQL Compare can save you time, whatever development model your team prefers to use. SQL Compare ensures accurate, fast results with maximum end-user flexibility.

Some of the procedures SQL Compare will automate for you:

Comparing two databases or a database with SQL scripts

Generating synchronization scripts

Taking database snapshots and comparing them – useful for audit trails

Comparing with a previous backup, ideal for database versioning

Executing "right-first-time" database synchronizations

Feature list:

Comparison and synchronization of SQL Server 2000, 2005 and 2008 database schemas, eliminating hours of tedious, error-prone manual work.

Comparison andsynchronizationof live databases or snapshots

Work directly withSQL script files under source control (Pro edition).

Compare and deploy from backups, whether native SQL Server (2000 – 2008) or Red Gate SQL Backup, compressed and uncompressed formats (Pro edition).

Deploy a live database from a set of object SQL scripts (Pro edition).

Integrate with your source control system with SQL Changeset (Pro edition).

Generate synchronization script so databases can be perfectly synchronized.

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 synchronization 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 synchronization 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.

For comparing and synchronizing database contents, check out SQL Compare's companion product, SQL Data Compare.

SQL Data Compare

SQL Data Compare is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It is one of the industry standard tools for comparing and synchronizing the contents of two databases because it is very reliable and also veryfast.

With SQL Data Compare's granular SQL change-scripts you can now restore damaged or missing data to a single row, without the need for a full database recovery, and that means you can fix database problems even faster.

With SQL Data Compare Pro, you can compare and synchronize SQL Server live databases with backups or simply compare two backups. With the command line interface you can automate tasks and schedule comparisons for easy compilation of an audit trail.

Find out when and how your data changed by comparing directly to backups. SQL Data Compare will save you many hours which you would otherwise spend copying, restoring and comparing databases with backups by hand; moreover, you can specify exactly which tables, rows, and columns from your databases you want to synchronize.

Some of the things SQL Data Compare can do for you:

Verify the success of your data migration

Create an audit trail by comparing backups

Restore missing or damaged data at table, row or column level

Troubleshoot your replication issues

Migrate data seamlessly between SQL Server 2000, 2005 and 2008

Provide an essential QA and documentation tool

Display row-data in columns (Pivot-view) for faster difference analysis

Run automated backups before synchronization

Optional compression of temporary files for improved performance

For comparing and synchronizing database schemas, check out SQL Data Compare's companion product, SQL Compare.

Feature list:

Comparison and synchronization of Microsoft SQL Server databases (2000 - 2008), eliminating hours of tedious, manual work.

Comparison with backups – native and compressed backup formats of SQL Server 2008 in addition to the backup files of SQL Server 2000 and 2005, and Red Gate's SQL Backup (Pro edition).

Fast Row Level Restore of damaged or missing data (Pro edition).

Full support for SQL Server 2008, including spatial, temporal and hierarchy data types, sparse columns, and new collations.

Full support for SQL Server 2005, including string into XML or CLR data type transformations and CLR, DDL and DML triggers.

Comparison on primary keys and unique indexesso you have the flexibility to define identical rows.

Custom comparison keys so you can compare databases based on any field – and it doesn't even need to be unique!

Support for indexed views so you can view data differences on views as well as tables.

'Pivot-view' difference navigation displays row data as columns for rapid identification and selection of data for synchronization.

Comparison and synchronization of large databases– works on databases with thousands of tables and gigabytes of data.

Simple to use and hides complexity from the user. Once the comparison has been completed, a script is automatically generated.

Integrates with SQL Query Analyzer or SQL Server Management Studio.

Option to transport CLR data types as text or binary for increased speed.

Mapping allowing you to compare tables, views, or even whole schemas, with different naming allowing for total flexibility.

SQL Packager

SQL Packager works by scripting and compressing the entire database – schema and data together – and packaging it up as a deliverable .exe file. It does this by scripting separate transactions for schema and data respectively. Highly customizable options enable you to generate package scripts to exactly fit your needs.

When migrating databases, all schema objects, all new tables and their data as well as data with unique indexes or constraints are also scripted.

Installing, updating, or distributing your database now becomes a simple point-and-click procedure. Deploy SQL Server databases, and your applications that depend on them, with no manual scripting. Exploit the command line options to automate the installation of database updates remotely.

By letting you compress your packaged database, you can reduce storage overhead and distribute it faster and more easily. SQL Packager also makes it easy to archive your database, and is an excellent solution for making a backup of your database where you don't have SQL Server administration rights.

SQL Packager Benefits:

Easy roll-out of database updates across your client base

Script and compress your schema and data accurately and quickly

Package any pre-existing SQL script as a .exe, or launch as a C# project

Simplify deployments and updates for SQL Server 2000, 2005 and 2008

SQL Dependency Tracker

Makes life easier.

Tracking dependencies by hand traditionally relies on the personal knowledge of whoever designed the database in the first place. If that person has moved on or is indisposed, business continuity suffers. Automated SQL Server dependency tracking and reporting minimizes downtime and ensures business continuity.

Tasks rendered dramatically faster by SQL Dependency Tracker include:

Quickly visualizing areas of complexity with dependency diagrams and text-based dependency checker

Tracking down potential "collateral damage" before you push database changes through

Simple documentation of object dependencies for archiving, reporting, version control, and auditing

Main Features include:

Fast dependency graphs mapping all SQL 2000, 2005 and 2008 objects

Powerful interactive graphical display in six zoomable layout modes

Print directly from the diagram or export as PDF

Proprietary dependency engine, independent of Microsoft sysdepends table

SQL Compare Bundle Updated:

SQL Compare 9.0 now supports SQL Azure databases.

SQL Compare Bundle Updated:

SQL Compare V8.5

New Features:

A free add-in for SQL Server Management Studio that enables you to set data sources to compare and synchronize from within SQL Server Management Studio

Fast deployment and Fast deployment projects: synchronization with one click (Pro feature)

Support of handling databases under SQL Source Control (using the add-in)

SQL Packager V6.4

Maintenance Release that fixes issues in 6.0

Plus

Include dependencies option

Uses the SQL Compare 8.5 and SQL Data Compare 8.5 engines

Compare, synchronize and package SQL database schemas and contents and track database and cross-database object dependencies.

Pricing: SQL Comparison Bundle 1 User License, SQL Comparison Bundle 5 User License, SQL Comparison Bundle 10 User License, SQL Comparison Bundle with 12 Months of Support and Upgrades 1 User License, SQL Comparison Bundle with 12 Months of Support and Upgrades 5 User License, SQL Comparison Bundle with 12 Months of Support and Upgrades 10 User License, SQL Comparison Bundle with 24 Months of Support and Upgrades 1 User License, SQL Comparison Bundle with 24 Months of Support and Upgrades 5 User License, SQL Comparison Bundle with 24 Months of Support and Upgrades 10 User License, SQL Comparison Bundle with 36 Months of Support and Upgrades 1 User License, SQL Comparison Bundle with 36 Months of Support and Upgrades 5 User License, SQL Comparison Bundle with 36 Months of Support and Upgrades 10 User License, SQL Comparison Bundle Renewal License - 12 Months of Support and Upgrades 1 User Renewal License, SQL Comparison Bundle Renewal License - 12 Months of Support and Upgrades 5 User Renewal License, SQL Comparison Bundle Renewal License - 12 Months of Support and Upgrades 10 User Renewal License, SQL Comparison Bundle Renewal License - 24 Months of Support and Upgrades 1 User Renewal License, SQL Comparison Bundle Renewal License - 24 Months of Support and Upgrades 5 User Renewal License, SQL Comparison Bundle Renewal License - 24 Months of Support and Upgrades 10 User Renewal License, SQL Comparison Bundle Renewal License - 36 Months of Support and Upgrades 1 User Renewal License, SQL Comparison Bundle Renewal License - 36 Months of Support and Upgrades 5 User Renewal License, SQL Comparison Bundle Renewal License - 36 Months of Support and Upgrades 10 User Renewal License

Evals & Downloads: Read the SQL Compare help file, Read the SQL Data Compare help file, Read the SQL Dependency Tracker help file, Read the SQL Packager help file, Read the SQL Compare Data sheet, Read the SQL Data Compare Data sheet, Read the SQL Packager Data sheet, Read the SQL Dependency Tracker Data sheet, Read the SQL Compare Database Development White Paper, Read the Red Gate End User License Agreement, Download the SQL Toolbelt evaluation on to your computer - Expires after 14 days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: MS SQL Azure, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000

Keywords: red gate sql comparison bundle, sql comparison bundle, redgate sql comparison bundle, red gate comparison bundle, buy sql comparison bundle, buy red gate comparison bundle, buy redgate comparison, sql comparison bundle reseller, red gate comparison bundle reseller, redgate comparison reseller, sql comparison bundle distributor, red gate comparison bundle distributor, redgate comparison distributor, price sql comparison bundle, price red gate comparison bundle, price redgate comparison, order sql comparison bundle, order red gate comparison bundle, order price redgate comparison, purchase sql comparison bundle, purchase red gate comparison bundle, purchase price redgate comparison, upgrade sql comparison bundle, upgrade red gate comparison bundle, upgrade redgate comparison, renew sql comparison bundle, renew red gate comparison bundle, renew redgate comparison

Red Gate Software Red-Gate RedGate

SQL query language

Development

Part numbers: PC-517515-428985 517515-428985 PC-517515-428987 517515-428987 PC-517515-428989 517515-428989 PC-517515-428991 517515-428991 PC-517515-428993 517515-428993 PC-517515-428995 517515-428995 PC-517515-428997 517515-428997 PC-517515-428999 517515-428999 PC-517515-429001 517515-429001 PC-517515-429003 517515-429003 PC-517515-429005 517515-429005 PC-517515-429007 517515-429007 PC-517515-429009 517515-429009 PC-517515-429011 517515-429011 PC-517515-429013 517515-429013 PC-517515-429015 517515-429015 PC-517515-429017 517515-429017 PC-517515-429019 517515-429019 PC-517515-429021 517515-429021 PC-517515-429023 517515-429023 PC-517515-429025 517515-429025

Mfr. Part No: P59U10M0 P59U10M12 P59U10M24 P59U10M36 P59U1M0 P59U1M12 P59U1M24 P59U1M36 P59U5M0 P59U5M12 P59U5M24 P59U5M36