=====================================================================
M S S Q L . S C H E M A D I F F   W I S H   L I S T
=====================================================================


---------------------------------------------------------------------
BUGS:
---------------------------------------------------------------------
- SQL calls need to use "WITH(NOLOCK)" to ensure never lock system tables
  in production.
                                                 - [Eric McKinlay]


- IsAnsiPadded name bug: No isansipadded column, app must be deriving it from 
  sys.columns.is_ansi_padded.  But, must have created the column (possibly in a 
  table variable) as isansipadded and then reference it as IsAnsiPadded.  
  I’ve tested on my case insensitive collations and I get by the issue.  
  If you change that casing to match (well, I guess you’d need to check 
  any others) you’ll have something that isn’t dependent on the database 
  being case-insensitive and comparison is fine.  

  FYI found renamed to "IsAnsiPadding".  Also suspect must remove 
  or fix "UsesAnsiTrim" property
                                                 - [Leigh Moncher]


- After clicking a command don't show "Not Responding" in title bar 
                                                 - [Bruce Bartram]


- Trim the left and right spaces, CRLF’s, etc. from sprocs and functions 
  so not show as different unless really are different.

- Turn Off [IsNotTrusted] by defaultb/c setup vs. update are different 
  and this difference does not matter usually.


- Nice addition to the tool is ability to output all of the differences 
  between schema into a single flat file report.  Sometimes not good enough
  to have the tree grid differences laid out on screen b/c need to expand
  each node and difficult to quickly email for corrective action, or easily
  attach to a bug write-up.  

  If tool exported all of the differences into a CSV file, then could 
  easily put it into Excel much faster and modify the resulting table 
  to meet my needs. 
 
  Example CSV report layout:
                
  ------------------  -----------------------  -----------------------------
  ObjectName          V1 Schema                V2 Schema
  ------------------  -----------------------  -----------------------------
  - TableX            ColumnA datatype = INT   ColumnA datatype = BIGINT
  - StoredProcedureA …SELECT * FROM TableA…    …SELECT TOP 100 * FROM TableA
 
                                                 - [Kyle Pierce]
                                                 - [David Luu] 2nd's report



---------------------------------------------------------------------
FUTURE ENHANCEMENT REQUESTS:
---------------------------------------------------------------------
- Add report button that quickly lists differences (enable after compare)

- Add support for DiffMerge, ExamDiff and/or other diffing tools 
  (beyond built-in DiffViewer)

- Command line driven, review syntax of other tools (also re-org like FileTouch)

- Add checkbox to auto-close status window when done; save to app 
  properties as default

- Add more granularity to step #33 Property Equivalence

- Add modify and create date properties + default to No Capture

- Add Help - FAQ link to WTG website.  Added FAQ items there.  May or 
  may not do this.

- Add ability to save schema dumps to XML (just dump the dataset, easy, 
  couple lines of code)

- Add ability to compare either database or schema dumps (so production can 
  compare to dev or vice versa)

- Add a copy feature for the tree node(s)  [David Grondin]

- Add Column Description to compare, and default it to optional

- Add option to ignore Replication system tables (“MSpeer_*”); and these
  tables also: sysarticlecolumns, sysarticles, sysarticleupdates,
  syspublications, sysreplservers, sysschemaarticles, syssubscriptions,
  systranschemas.





---------------------------------------------------------------------
CANCELLED ENHANCEMENT REQUESTS:
---------------------------------------------------------------------
- n/a