by Red Gate Software - 製品のタイプ: Application
SQL Compare Pro by Red Gate Software
Compare and synchronize SQL Server database schemas. SQL Compare is a tool for comparing and synchronizing SQL Server database structures. It is 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 Compare Pro contains a command-line interface and you can compare and synchronize SQL Server database schemas and automate tasks.
SQL Compare Pro - for simpler automation, versioning and source control integration:
Compare and synch with a set of script files.
Object Level Restore from a backup file.
Includes SQL Changeset for integrated checkin/edit/checkout.
Accesses command-line interface.
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.
PartNumbers: PC-516295-169411 516295-169411 PC-516295-169412 516295-169412 PC-516295-169413 516295-169413 PC-516295-169414 516295-169414 PC-516295-169415 516295-169415 PC-516295-169416 516295-169416 PC-516295-169417 516295-169417 PC-516295-169418 516295-169418 PC-516295-169419 516295-169419 PC-516295-169420 516295-169420 PC-516295-169421 516295-169421 PC-516295-169422 516295-169422 PC-516295-169423 516295-169423 PC-516295-169424 516295-169424 PC-516295-169425 516295-169425 PC-516295-169426 516295-169426 PC-516295-169427 516295-169427 PC-516295-169428 516295-169428 PC-516295-169429 516295-169429 PC-516295-169430 516295-169430 PC-516295-169431 516295-169431
Publisher PartNumbers: P49U10M0 P49U10M12 P49U10M24 P49U10M36 P49U1M0 P49U1M12 P49U1M24 P49U1M36 P49U5M0 P49U5M12 P49U5M24 P49U5M36
PurchaseOptions: SQL Compare Pro V7.1 1 User License , SQL Compare Pro V7.1 5 User License , SQL Compare Pro V7.1 10 User License , SQL Compare Pro V7.1 with 12 Months of Support and Upgrades 1 User License , SQL Compare Pro V7.1 with 12 Months of Support and Upgrades 5 User License , SQL Compare Pro V7.1 with 12 Months of Support and Upgrades 10 User License , SQL Compare Pro V7.1 with 24 Months of Support and Upgrades 1 User License , SQL Compare Pro V7.1 with 24 Months of Support and Upgrades 5 User License , SQL Compare Pro V7.1 with 24 Months of Support and Upgrades 10 User License , SQL Compare Pro V7.1 with 36 Months of Support and Upgrades 1 User License , SQL Compare Pro V7.1 with 36 Months of Support and Upgrades 5 User License , SQL Compare Pro V7.1 with 36 Months of Support and Upgrades 10 User License , SQL Compare Pro V7.1 Renewal License - 12 Months of Support and Upgrades 1 User Renewal License , SQL Compare Pro V7.1 Renewal License - 12 Months of Support and Upgrades 5 User Renewal License , SQL Compare Pro V7.1 Renewal License - 12 Months of Support and Upgrades 10 User Renewal License , SQL Compare Pro V7.1 Renewal License - 24 Months of Support and Upgrades 1 User Renewal License , SQL Compare Pro V7.1 Renewal License - 24 Months of Support and Upgrades 5 User Renewal License , SQL Compare Pro V7.1 Renewal License - 24 Months of Support and Upgrades 10 User Renewal License , SQL Compare Pro V7.1 Renewal License - 36 Months of Support and Upgrades 1 User Renewal License , SQL Compare Pro V7.1 Renewal License - 36 Months of Support and Upgrades 5 User Renewal License , SQL Compare Pro V7.1 Renewal License - 36 Months of Support and Upgrades 10 User Renewal License
Resources: Read the SQL Compare Data sheet, Read the SQL Data Compare 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: Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000
Keywords: Database DB Reporting Report reports SQL query language Red Gate Software Red-Gate RedGate Database DB Management Professional Partner Compare sql synchronize synchronization schema database structure development replication replicate SQL standard query language database databases querying queries access server redgate