Description
SQL Compare Suite simplifies database development, maintenance, and hot-fixing. Its database version control makes it possible to MS SQL Server developers to compare and synchronize database structures between development and production systems without affecting existing data. The new SQL compare tool analyzes changes in the database structure, creates a hot-fix, and applies the changes on the production server while preserving data stored in the database.
Compatible with Microsoft SQL Server 7.0, 2000, 2005, and 2008, SQL Compare Suite supports all types of objects supported by SQL Server. The new SQL compare engine can compare SQL databases with data dumps, SQL scripts, live databases and snapshots, making it possible to transfer database structure changes between a variety of applications.
The smart SQL compare engine makes efforts to preserve all existing data in the production database. An updated database structure can remove certain types of records, prohibit NULL values, or implement other changes that would make an updated database invalid. The SQL compare engine analyzes structural modifications being applied to existing database, alerting if any conflicts between the new structure and existing data are found. The user can choose among several options, such as filling incompatible records with default values, ignoring the conflict or canceling synchronization. Optional partial synchronization mode allows the user to only apply some changes while ignoring the rest.
The SQL compare engine is capable of performing complex synchronization tasks, such as synchronizing dependent objects. The new SQL compare engine turns SQL Compare Suite into a fully-featured database version control system. The available command-line utility enables automated and scheduled updates.
Related:
Compare Databases - Database Compare - Database Synchronization - Sql Compare
User Reviews:
Related:
Habanero Pro v1.1Habanero is an object-relational mapping (ORM) architecture for .Net that maps object-oriented code to relational databases. It persists data to...By: Eric Savage |
Demo |
Oracle Reports Barcode PLL with PL SQL Source 1.2Add barcodes to Oracle Reports with this library. The bar code library is a PLL file that formats data from fields in the report to barcode fonts....By: Brant Anderson |
Demo |
Rapid Query 1.0Rapid Query is a database (administration tool) manager supporting Access, MySQL, PostgreSQL, SQL Server, Oracle databases and ODBC sources. It has...By: Damir Bulic |
Shareware |
ModelRight Community 3Whether you are a beginner or an expert database modeler, ModelRight 3 is your answer when you need a database modeling tool that surpasses the...By: Tim Guinther |
Freeware |
Access Object Navigator 3.0Access Object Navigator 3.0 is a complete user interface for Access database solutions. It is an Access add-on that provides you the Outlook-like...By: Sasa Smiljanec |
Demo |
Database Comparer 3.1Database Comparer helps to compare, synchronize and update databases structure. You can compare one database with another database or database with... |
Freeware |
AdeptSQL Workshop 1.0The complete IDE for creating and managing databases from SQL scripts, including macro preprocessor, syntax-oriented editor, schema...By: Adept SQL Tools |
Shareware |
AdeptSQL Diff 1.00With AdeptSQL Diff, you can visually compare two MS SQL Server databases, then produce and execute difference scripts for a choosen part or for the...By: Adept SQL Tools |
Shareware |
SQL Delta 3.1SQL Delta is a great value, fast SQL database compare tool used to analyze, compare and synchronize database structures and data. SQL Delta... |
Shareware |
SQL Examiner 1.2SQL Examiner is a program which compares and synchronizes the schemas of different versions of SQL server databases no matter how complex their...By: TulaSoft |
Shareware |
- SQL Test Suite
The technical goal of the test suite is to help evaluate an SQL implementation's conformance to Entry SQL or Intermediate... - Compare It
A full-featured visual file comparison and merging tool. Enables you to compare and work with different versions of the... - Beyond Compare
Scooter software's Beyond Compare is a Windows utility that combines directory compare and file compare functions in one... - LINQ to SQL and Entity Framework on top of SQL Azure
How to create a designer for working with LINQ with SQL Azure by Kevin Hoffman. - The SQL Summit: Understanding SQL/XML and Information Retrieval
Portal site with information about databases, SQL/XML, XQuery, modeling, information retrieval, and web and grid data... - How to Transfer SQL Logins between SQL Server 2005 Instances
Articles presents a custom script as well as standard options for moving SQL logins between servers by Tara Kizer. - Compare and Merge
Visual file and folder comparison utility. Product download, and an online user manual. [Shareware for Windows] - Compare & Backup
Backup software that allows one to compare source with destination before backup. FAQs, screenshots, download, and purchase. - Compare web hosts
Search and compare detailed web hosting services and pricing plans. - Compare Internet Fax Services
Comparison and reviews of Internet fax and email fax services. Includes a guide to choosing an Internet fax service.