SQL Compare - 개요

by Red Gate Software - 상품타입: Application

요약

SQL Compare by Red Gate Software

Compares and synchronizes 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 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-169390 516295-169390 PC-516295-169391 516295-169391 PC-516295-169392 516295-169392 PC-516295-169393 516295-169393 PC-516295-169394 516295-169394 PC-516295-169395 516295-169395 PC-516295-169396 516295-169396 PC-516295-169397 516295-169397 PC-516295-169398 516295-169398 PC-516295-169399 516295-169399 PC-516295-169400 516295-169400 PC-516295-169401 516295-169401 PC-516295-169402 516295-169402 PC-516295-169403 516295-169403 PC-516295-169404 516295-169404 PC-516295-169405 516295-169405 PC-516295-169406 516295-169406 PC-516295-169407 516295-169407 PC-516295-169408 516295-169408 PC-516295-169409 516295-169409 PC-516295-169410 516295-169410

Publisher PartNumbers: P18U10M0 P18U10M12 P18U10M24 P18U10M36 P18U1M0 P18U1M12 P18U1M24 P18U1M36 P18U5M0 P18U5M12 P18U5M24 P18U5M36

PurchaseOptions: SQL Compare V7.1 1 User License , SQL Compare V7.1 5 User License , SQL Compare V7.1 10 User License , SQL Compare V7.1 with 12 Months of Support and Upgrades 1 User License , SQL Compare V7.1 with 12 Months of Support and Upgrades 5 User License , SQL Compare V7.1 with 12 Months of Support and Upgrades 10 User License , SQL Compare V7.1 with 24 Months of Support and Upgrades 1 User License , SQL Compare V7.1 with 24 Months of Support and Upgrades 5 User License , SQL Compare V7.1 with 24 Months of Support and Upgrades 10 User License , SQL Compare V7.1 with 36 Months of Support and Upgrades 1 User License , SQL Compare V7.1 with 36 Months of Support and Upgrades 5 User License , SQL Compare V7.1 with 36 Months of Support and Upgrades 10 User License , SQL Compare V7.1 Renewal License - 12 Months of Support and Upgrades 1 User Renewal License , SQL Compare V7.1 Renewal License - 12 Months of Support and Upgrades 5 User Renewal License , SQL Compare V7.1 Renewal License - 12 Months of Support and Upgrades 10 User Renewal License , SQL Compare V7.1 Renewal License - 24 Months of Support and Upgrades 1 User Renewal License , SQL Compare V7.1 Renewal License - 24 Months of Support and Upgrades 5 User Renewal License , SQL Compare V7.1 Renewal License - 24 Months of Support and Upgrades 10 User Renewal License , SQL Compare V7.1 Renewal License - 36 Months of Support and Upgrades 1 User Renewal License , SQL Compare V7.1 Renewal License - 36 Months of Support and Upgrades 5 User Renewal License , SQL Compare 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

상품검색

검색어를 입력해주세요:

Quick 링크