dbForge Schema Compare is a reliable, easy-to-use tool to compare and synchronize structures of Microsoft SQL Server databases.
This product is specially designed to help you quickly analyze database structure differences at a glance and propagate the changes to a required SQL Server escaping tedious manual work.
This software will support quick comparison of the whole database structure or will process only specific objects - views, tables, user defined functions, stored procedures, etc.
Here are some key features of "dbForge Schema Compare for SQL Server":
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
Database Structure Comparison:
· Accurate comparison with Schema Comparison wizard
· Comparison of all major SQL Server database objects
· Options for tables and script-based objects comparison
· Object filter to compare only required object types
· Custom schema mapping (one-to-one, one-to-many, or many-to-one)
Analyzing Structure Differences and Synchronization:
· Automatic grouping of objects by type
· Convenient filtering and sorting of comparison results
· Objects exclusion from synchronization
· Save and load comparison settings
· Detailed synchronization script plan
· View the synchronization script for any separate schema object
· Ability to backup the Target database before synchronization
· Automatically compiled list of objects to add to the synchronization based on object dependencies
· Options to customize the synchronization script output
· Warnings on possible data losses or errors during synchronization
· Asynchronous structure 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)
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
Requirements:
· .NET Framework 2.0 SP1, 3.0, or 3.5
· 30 MB of free hard disk space
Limitations:
· 30 days trial period
· Nag screen
What's New in This Release: [ read full changelog ]
· The problem with the temporary table on schema synchronizing is fixed
· The problem with procedure's dependencies determination on schema comparison is fixed
· InvalidOperationException on executing a script is fixed
· ArgumentException on saving command line arguments in the Schema Comparison wizard is fixed
Find us on Google+
