產(chǎn)品功能

• 分析和同步SQL Server數(shù)據(jù)庫架構(gòu)

• 實(shí)時(shí)架構(gòu)分析和SQL Server數(shù)據(jù)庫備份

• 生成Excel和HTML格式分析報(bào)告

• 分析數(shù)據(jù)庫應(yīng)用程序更新影響

• 消除架構(gòu)的更改在不同環(huán)境中產(chǎn)生的錯(cuò)誤

• 跟蹤生產(chǎn)數(shù)據(jù)庫的更改和自定義

• 制作模式快照保存在數(shù)據(jù)庫開發(fā)過程點(diǎn)

• 使用命令行界面架構(gòu)更改自動(dòng)遷移

• 使用源代碼控制集成改進(jìn)SQL Server架構(gòu)版本

產(chǎn)品優(yōu)勢(shì)

• 加快應(yīng)用開發(fā)得益于數(shù)據(jù)庫部署和測(cè)試自動(dòng)化周期

• 較低的企業(yè)應(yīng)用程序的生命周期成本

• 加快由于升級(jí)對(duì)定制跟蹤影響應(yīng)用程序升級(jí)

• 減少因應(yīng)用程序更改系統(tǒng)停機(jī)時(shí)間，加快恢復(fù)

What schema comparison and synchronization tool do you need?

Anything able to compare and synchronize database schemas or packed with extended functionality? Want clear schema differences and safe database synchronization? Search for a stable SQL Server schema compare tool?

dbForge Schema Compare for SQL Server delivers!

• Rich features set
• Best bang for your buck
• Remarkable customer support
• Standard and Professional editions
• 30-day fully functional trial!

Synchronize any database

 Dependencies between and inside database objects often prevent successful schema synchronization. Object dependencies are complex, so you need some magic to get a correct synchronization. Many synchronization tools still fall down. dbForge Schema Compare has a special tried-and-true parser to find all the object dependencies and show you what objects you have forgotten to include into synchronization.

 This guarantees that you can synchronize any object regardless of how many dependencies it has. Try dbForge Schema Compare on your database. Delivering qualitative schema comparison and synchronization is our fame.

Ignore minor differences without corrupting a target schema

 Customize database comparison using multiple "Ignore" options provided by dbForge Schema Compare. Concentrate on necessary schema differences, get exact and easy-to-analyze comparison results. Be sure, ignored object properties won't be modified implicitly after synchronization. Whatever database objects you compare, get the accurate result.

Compare native SQL Server backups

 Compare a live database with a SQL Server backup with ease. dbForge Schema Compare is the quickest in opening big database backup files (tested on 50Gb files).

Put your database schema under a version control

 Stop suffering from merging database changes. Enhance team database development with the version control. dbForge Schema Compare supports most popular ones – Microsoft Team Foundation Server and Subversion.

 Make a schema snapshot and put under a version control. Revert to earlier revisions, quickly identify who and when changed the objects, get convenient snapshots management in a version control repository.

Verify data integrity after synchronization

 Protect any table changes with automatic and timely detection of any data losses. dbForge Schema Compare checks table data after synchronization and notifies if any data loss has happened. Relax and leave the dirty job to a professional tool!

Get more tools to compare and synchronize databases with delight

• Command line interface
• Script executor to execute large SQL scripts that can cause "out of memory" errors.
• Navigation to schema synchronization errors to quickly find them.
• Start page to provide a one-click access to a set of high-usage tools and launch previous comparisons with a click.
• Multi-document interface to compare and synchronize various databases at once.
• Quick and useful context-sensitive help documentation.