彩票走势图

查看视频

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