SQL Compare Tool to Synchronize SQL Server Databases Automatically »
Posted By Hawla 5 months, 1 week ago in Science & TechnologyOngoing maintenance of a database being used in a production system is very common. Developers have to invent various means of synchronizing database structures between development and production systems in order to apply any modifications. Changes to database structure are often unavoidable in order to facilitate new features or fix bugs. Unfortunately, the beaten path of producing database synchronization scripts for every update of a structure is sub-optimal when it comes to data integrity, safety and effectiveness of the update process. SQL Examiner ( <a href="http://www.sqlaccessories.com/">... ) enables simple synchronization of database structures between development and production systems running under Microsoft SQL Server engine. SQL Examiner 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 Examiner 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. However, some modifications to the database structure can make data preservation hard to achieve. For example, 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 Examiner into a fully-featured database version control system. The included command-line utility enables automated and scheduled updates. The free trial version of SQL Examiner is available for download at: <a href="http://www.sqlaccessories.com/">...
Read Full Story at sqlaccessories.com »
50 Views Share Story 0 Comments Report
Other Related Articles: All »
More News
Download Squad
Skype 4.2 beta for Windows adds call transfer, Chrome browser plugin
HootSuite launches iPhone Twitter client, with stats and scheduled tweets
RealNetworks brings COLLAPSE! to practically every platform
Chirp: Twitter app development gets big enough for its own conference
Shocker: study shows visual alerts distract you from doing work
Add a Comment
Sign In With Your Propeller Account
Please keep your comments relevant to this story.
To create a live link, simply type the URL (including http://) or email address and we will make it a live link for you. You can put up to 3 URLs in your comments. Line breaks and paragraphs are automatically converted — no need to use <p> or <br /> tags.