Tool to compare SQL Schema?

11 Sep 2006 2:34 PM

DotNetDev

Hi,

Can any one recommend a tool (Free lisc, preferred) to compare SQL Schema
(and may be data)?

Thanks

11 Sep 2006 2:53 PM

SQL Menace

The one I use is Red Gate SQL Compare
(http://www.red-gate.com/products/sql_compare/index.htm)

and

SQL Data Compare
(http://www.red-gate.com/products/SQL_Data_Compare/index.htm)

It's not free but it isn't expensive either, you can buy them as a
bundle
Download the trial version and see if you like them

Denis the SQL Menace
http://sqlservercode.blogspot.com/

DotNetDev wrote:

Show quote

> Hi,
>
> Can any one recommend a tool (Free lisc, preferred) to compare SQL Schema
> (and may be data)?
>
> Thanks

11 Sep 2006 4:03 PM

DotNetDev

Thnx

Show quote

"SQL Menace" wrote:

> The one I use is Red Gate SQL Compare
> (http://www.red-gate.com/products/sql_compare/index.htm)
>
> and
>
> SQL Data Compare
> (http://www.red-gate.com/products/SQL_Data_Compare/index.htm)
>
> It's not free but it isn't expensive either, you can buy them as a
> bundle
> Download the trial version and see if you like them
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>
> DotNetDev wrote:
> > Hi,
> >
> > Can any one recommend a tool (Free lisc, preferred) to compare SQL Schema
> > (and may be data)?
> >
> > Thanks
>
>

11 Sep 2006 5:01 PM

sualeh.fatehi

The free, open-source SchemaCrawler tool will do what you need.
SchemaCrawler outputs details of your schema (tables, views,
procedures, and more) in a diff-able plain-text format (text, CSV, or
XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs)
in the same plain-text formats. You can use a standard diff program to
diff the current output with a reference version of the output.
SchemaCrawler can be run either from the command line, or as an ant
task. A lot of examples are available with the download to help you get
started.

SchemaCrawler is free, open-source, cross-platform (operating system
and database) tool, written in Java, that is available at SourceForge:
http://schemacrawler.sourceforge.net/
You will need to provide a JDBC driver for your database. No other
third-party libraries are required.

Sualeh Fatehi.

14 Sep 2006 4:31 PM

knightconsulting

for data comparisons try Firefly SQL Compare. It's free, i wrote it
myself for comparing data from two different queries running on two
different database systems.

http://www.getfirefly.net/
http://www.getfirefly.net/FF_Screen_1_Small_4.png

Regards,
James