Re: Export the whole DB to ASCII file
From: Sualeh Fatehi <sualeh.fatehi_at_gmail.com>
Date: Thu, 10 Apr 2008 10:19:37 -0700 (PDT)
Message-ID: <a3416ed7-7345-4e9a-82f8-b03e445c665b@m44g2000hsc.googlegroups.com>
Date: Thu, 10 Apr 2008 10:19:37 -0700 (PDT)
Message-ID: <a3416ed7-7345-4e9a-82f8-b03e445c665b@m44g2000hsc.googlegroups.com>
Pavel,
The free, open-source SchemaCrawler for SQL Server tool will do this
for you. You can take human-readable snapshots of the schema and data,
for later comparison. Comparisons are done using a standard diff tool
such as WinMerge. 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.
SchemaCrawler is available at SourceForge: http://schemacrawler.sourceforge.net/
Sualeh Fatehi Received on Thu Apr 10 2008 - 12:19:37 CDT