查看視頻

Compare and Sync SQL Server Databases

dbForge SQL Server數據比較是一種功能強大的SQL比較工具，可以輕松處理大數據并支持本機SQL Server備份。使用dbForge Data Compare，您可以調整無缺陷的SQL數據庫比較，快速分析SQL數據差異，將靜態數據與版本控制的數據庫進行比較，以及使用方便的向導平穩地同步SQL Server數據。該工具與SQL Server Management Studio集成。

檢測實時數據庫，備份或腳本文件夾之間的數據更改

生成T-SQL腳本，用另一個數據庫的內容更新一個數據庫

從本機備份將損壞或丟失的數據還原到一行

將查找數據從開發數據庫復制到暫存或生產中

在Amazon RDS上部署到SQL Server，SQL Azure和SQL Server

使用命令行界面自動執行常規數據同步任務

將數據比較結果導出到CSV，HTML和Excel

SQL Server Connectivity

• Support of SQL server 2008, 2005 (including Express editions), and 2000 (including MSDE edition)
• Comparison and synchronization of databases on different SQL servers
• Connection Manager for a full control of database connections

Data Comparison

• Accurate comparison with Data Comparison wizard
• Comparison of tables and views
• Custom mapping of tables, columns, views, and schemas
• Custom comparison keys support
• BLOB data comparison

Analyzing Data Differences and Synchronization

• Automatic grouping of records in every compared object by type (different, equal, only in Source, only in Target, and conflict)
• Convenient filtering of comparison results
• One-click objects (or their records) exclusion from synchronization
• Save and load comparison settings
• Detailed synchronization script plan
• Ability to backup Target database before synchronization
• Warnings on possible data losses or errors during synchronization
• Notifications on data overflow, roundings, etc.
• Asynchronous data synchronization

SQL Execution and Data Management

• Execution of SQL scripts and queries
• Data editor with in-place filtering, grouping, and sorting options
• Paginal data access for large result sets
• Graphical card view for data editor
• Large objects (LOB) editor
• Text search in data editor
• Data printing
• Ability to postpone sending of data updates to the server (Cached updates mode)
• Data export wizard

Clear User Interface

• Customizable window layout
• Tool windows with 'auto-hide' and 'float' modes
• Multiple shortcut schemes with full shortcut customization
• Tabbed groups for documents
• Toolbars customization