Hi,

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

Thanks

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 quoteHide quote

Thnx

Show quoteHide quote

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.

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

Storing all Upper Case value
How to pass a list of parameters from Select Table
Database design question
Trigger ID
Database Id prb !
c sql server library?
URGENT - Cannot find bad data in table
Fast "InUse" flag.
Service Broker
Rollback actions of SP