Date parsed: 29/01/2008 19:38:29
Date: Wed, 30 Jan 2008 03:38:29 -0800 (PST)

Try doing a schema compare using the free, open-source SchemaCrawler
for SQL Server tool. 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

Date parsed: 17/04/2008 14:48:52
Date: Thu, 17 Apr 2008 14:48:52 GMT

Hi Steve,
Thank you very much for your detail description so that I can effectively
understand your meaning and reproduce your issue accordingly. I performed a
detail test today and I found an interested thing. Your issue can either be
reproduced or not be reproduced at my side. For why, please refer to my
explanations as following.
Per my investigation, they behave differently in two different situations:
1. When database A and database B have different database collations
In this case, those varchar/nvarchar columns will be showed different and
in their column definitions COLLATE statements are appended.
2. When database A and database C have same database collation
In this case, they are equal.

I think that your two databases may have different collations. That is why
you saw they were different in your database project. You can check their
collations by running SELECT DATABASEPROPERTYEX('<database
name>','COLLATION') in SQL Server Management Studio.

This is the reason why they were showed different, however you can also
have them appear equal even they are with different collations. The mystery
is here:
Select Tools->Options->Database Tools->Schema Compare, in the Advanced
schema compare options, select the following options: Ignore collation
order, Ignore check constraints, Ignore constraint and index names.Then
click the refresh button, and you will see they are equal.


Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================