Projects tagged ‘compare’ and ‘sql’

The SQL Schema Tool or SST as it is now known started as a command-line developer’s tool. As such, the tool was designed to assist developers working against a SQL server database, so as to migrate ... [More] any database changes from a development environment into a test or nightly build environment. The SST is an application for generating XML schema documents from SQL server databases, comparing those databases or the XML schema documents, and finally generating a DiffGram XML document from the compare results. Simply put, the purpose is to make a snapshot of the current latest database schema and merge those changes into a build of the previous database schema (live or snapshot). The tool can make snapshots of databases, DTS packages, or even the data itself, to perform offline compare(s) and create update script(s). The tool can also be used to generate schema create scripts for archival or source control purposes. As developers, testers, or deployment people, we want to take database B, and make it look like database A. See the Codeproject Article for additional information about the project. [Less]

As a software product evolves it is inevitable that the underlying database schema changes and you have to make sure any changes you make in the development cycle are made to all other database as the ... [More] software is distributed. In all our products we include a database management module that propagates changes out to live databases and ensures the version of the software matches the database schema. In the early stages of development though the schema changes made by designers and developers come fast and furious and it can be difficult keeping track of them and propagating them to other databases. At Paritor we have this problem and find it can be a long winded job comparing databases manually. There are tools out in the marketplace to analyse databases, show differences and even script any necessary changes but apart from the fact that they all cost money they all seem to be a "Sledge Hammer to Crack a Walnut". I therefore sat down the other morning and put together a simple utility to open up two database, analyse the differences and report on what it finds. I wrote it as a WPF application, mainly because I wanted to use the WPF Document namespace to create the report and show it using the WPF Document Viewer. You could easily write it as a Windows forms and use System.Drawing.Print or even produce a Crystal Report. [Less]

The need for some (free) tools to compare data sources in both schema and data. The application must be plug-in friendly, so any custom data source comparer can be added.

Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008. It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.