SQL Comparison Bundle(英語版)
SQLデータベーススキーマとコンテンツの比較、同期、パッケージ化、データベースオブジェクト間の依存関係の追跡
Redgate Software 社の製品
2005 年より日本国内にてComponentSourceで販売中。
SQLデータベーススキーマとコンテンツの比較、同期、パッケージ化、データベースオブジェクト間の依存関係の追跡
SQL Comparison Bundle には、SQL Compare という SQL Server のデータベース構造を比較、同期のためのツールが含まれていて、150,000 人を超えるデータベース管理者、開発者、テスターが使用しています。SQL Compare は、ローカル データベースに加えられたデータベースの変更内容をリモート サーバー上のテスト、稼働、ライブ データベースに配布するプロセスを自動化します。2 つのデータベース間でデータが同期していない場合、SQL Data Compare を使用して、同期させる上で面倒な大量の作業を節約します。また、QA、ドキュメント、検証を目的としたツールとしても使用できます。SQL Packager は、Microsoft SQL Server のデータベース構造や内容またはデータベース アップグレードを .NET 実行可能ファイルや C# プロジェクトにパッケージ化します。そのため、データベースのインストールははるかに容易になります。インストールまたは配備の目的でこのツールを使用して、データベース構造、データ、またはその両方をパッケージ化できます。SQL Dependency Tracker は、さまざまなグラフィカルなレイアウトを使用して、動的にすべてのデータベース オブジェクトの依存関係を調べることができます。Microsoft SQL 2000/2005/2008 の大量のデータベースを分析し、すべてのデータベース変更について徹底的に事前にインパクト分析を行うための、読みやすい依存関係ダイアグラムを作成することができます。
SQL Comparison Bundle includes:
SQL Compare
SQL Compare compares and synchronizes SQL Server database schemas.
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:
Feature list:
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:
For comparing and synchronizing database schemas, check out SQL Data Compare's companion product, SQL Compare.
Feature list:
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:
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:
Main Features include: