Free sql database comparison software for windows

SiteMechanics Database Manager 1 has come as a convenient and comprehensive tool with the ability to backup and exchange data between Microsoft SQL Server databases. It allows to export entire database or particular tables to a file. You can choose between XML, SQL or DataSet file formats. Later you can import saved file to a local or remote database.

Very Simple Database Inspector 2.2 is known as a free yet very useful database comparison and synchronization tool designed to synchronize structures between two or more databases. Compare tables, columns, primary keys, stored procedures, views, functions, triggers, and indexes all from one interface. Save your common synchronizations, interface with third party software, customizable rules engine, search databases, save sql scripts and synchronize mapping/lookup tables. Supports Microsoft Sql Server and Microsoft Access.

Major Features:

1. Compare Databases
   • Compare the structure of two databases, and highlight the difference
2. Synchronize Databases
   • Once the differences are identified, you can update the destination database with a click of the mouse
3. Multiple Database Types
   • The database inspector supports a variety of database types, all in one package
4. Easy to Use
   • The database inspector has been designed with ease of use and transparency in mind. All SQL may be viewed before it is run on the destination database, and you can see the structure of the destination at any time. The database inspector will even alert you if a change is going to cause problems or cannot be run
5. Sql Editor
   • Unlike other synchronization software, the database inspector allows you to make changes to your sql on the spot. No more copy/paste to third party editors
6. Save Frequent Work
   • Save your common comparisons for quick reference later. The database inspector has been created to make deploying your database changes as painless as possible
7. Command Line Support
   • All features of the database inspector may be accessed via the command line, allowing to generate and store script files any on your computer, at any time.
8. Scripting
   • Run changes immediately on your destination database, or save to a script file for updating later or archiving.
9. Multiple Database Support.
   
10. Structure Synchronization.
    
11. Synchronize Mapping Tables.
    
12. Helpful Warnings and Suggestions.
    
13. Search Function.
    
14. Rules Wizard.
    
15. Third Party Integration.
    
16. Script Database Changes.
    
17. Synchronize Databases from the Command Line.
    

Enhancements:

• Version 2.2 adds command line support: see the command line tab at the top of the main window.
• Columns of type 'decimal' now have their precision and scale synchronized
  
• Inspector Engine no longer displays error message when synchronizing the mapping table of a single database
  
• Minor performance enhancements
  

Sql Server Script 1 is a utility for database developers to transfer MS SQL Server data into SQL script. Application is very fast and easy to use. You can script SQL Server Data from individual table and from all tables in database.