Compare tables from one server/database to another

Hello,
I know for mysql there is a tool that compares tables (like a windiff tool).
Is there anything for MS SQL?
thanks
WilfridThere's no built-in compare tool that comes with SQL Server. You can script
objects and compare with a text file diff tool like Windiff or
BeyondCompare.
There are also third-party tools available like SqlCompare
(http://www.red-gate.com/products/sql_compare/index.htm). If you have
Visual Studio 2005, the CTP3 of the Team Edition for Database Professionals
(http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx)
has a schema compare feature, among others.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Wilfrid" <grille11@.yahoo.com> wrote in message
news:449bbb8e$0$31655$636a55ce@.news.free.fr...
> Hello,
> I know for mysql there is a tool that compares tables (like a windiff
> tool).
> Is there anything for MS SQL?
> thanks
> Wilfrid
>|||You could try ApexSQL's SQLCompare tool. Try the 30 day fully functional
evaluation version.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Wilfrid" <grille11@.yahoo.com> wrote in message
news:449bbb8e$0$31655$636a55ce@.news.free.fr...
> Hello,
> I know for mysql there is a tool that compares tables (like a windiff
> tool).
> Is there anything for MS SQL?
> thanks
> Wilfrid
>|||Wilfrid -- xSQL Software has a great and free comparison and
synchronization tool that you can get from
http://www.x-sql.com/download.aspx (the free edition supports smaller
databases) -- also an sdk that allows you to integrate the comparison
and synchronization functionality in your application is available.
CJK
Wilfrid wrote:
> Hello,
> I know for mysql there is a tool that compares tables (like a windiff tool).
> Is there anything for MS SQL?
> thanks
> Wilfrid|||Wilfrid,
The 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 jars are required.
Once you get familiar with SchemaCrawler's Java API, you can even write
plug-ins that will automatically generate the scripts that you need.
Sualeh Fatehi.