Schema differencing tool?

10 Feb 2006 4:14 PM

Robert Davis

Can I get your recommendations on the best schema differencing tool to be
had?

TIA!

Robert

10 Feb 2006 4:23 PM

Aaron Bertrand [SQL Server MVP]

SQL Compare 4.0. By far.
http://www.red-gate.com/

Show quote

"Robert Davis" <radb***@yahoo.com> wrote in message
news:%23AHiV0lLGHA.3100@tk2msftngp13.phx.gbl...
> Can I get your recommendations on the best schema differencing tool to be
> had?
>
> TIA!
>
> Robert
>

10 Feb 2006 4:27 PM

Geoff N. Hiten

I second that recommendation

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

Show quote

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uBxtZ3lLGHA.532@TK2MSFTNGP15.phx.gbl...
> SQL Compare 4.0. By far.
> http://www.red-gate.com/
>
>
>
> "Robert Davis" <radb***@yahoo.com> wrote in message
> news:%23AHiV0lLGHA.3100@tk2msftngp13.phx.gbl...
>> Can I get your recommendations on the best schema differencing tool to be
>> had?
>>
>> TIA!
>>
>> Robert
>>
>
>

13 Feb 2006 2:51 PM

sualeh.fatehi

If you are willing to use a Java-based tool in your environment, you
can use SchemaCrawler, a free open-source tool that can compare schemas
as well as data. SchemaCrawler is a command-line tool to output your
database schema and data in a readable form. The output is designed to
be diff-ed with previous versions of your database schema.

http://schemacrawler.sourceforge.net/

All you will need is a JDBC driver, and any diff tool such as WinMerge.

Sualeh Fatehi.