FieldMapping not valid for MatchingMappings

• 
  As far as I know, this exception should not happen in SQL Data Compare because it should prevent you from being able to map columns that can't be compared because of a difference in the datatype.
  
  Usually I see this message coming from SQL Comparison SDK apps. If you are using DataCompare.Engine.dll, I'd suggest throwing in some logic to check the MappingStatus field of every column mapping before you proceed to the comparison phase.

  Brian Donahue August 08, 2011 06:38

  - 0 +
• 
  The problem turned out to be with Data Compare after all, and the fix was to create a new project. The old project had some outdated schema information after some column datatypes had been changed.
  
  Normally this wouldn't cause a problem so I suspect maybe the project had been created in an older version of Data Compare, but I've got no way of checking that.

  Brian Donahue August 08, 2011 12:26

  - 0 +
• 
  I still get this error in SQL Data Compare 9.0.0.117
  
  In the past, I've just created a new project. It is tiresome to re-discover the various settings I had set for comparing certain database pairs.
  Perhaps the product could give a more descriptive message, such as which table or column, or what we can do about it?

  kipb7 August 18, 2011 12:19

  - 0 +
• 
  This error is still present in 10.2.0.315.

  tschlarm July 23, 2012 16:52

  - 0 +
• 
  We were receiving the same error and found that it was due to a single table that had changed schema and the comparison file no longer could reconcile the mappings. To fix, you can open the .sdc file in a text editor (I recommend Notepad++) and cut out the bad table nodes. Then you can open the file in RedGate, re-select the table, and re-compare. Hope this helps!
  
  Thanks,
  Kevin

  redkev March 07, 2013 15:31

  - 0 +
• 
  I found and easier fix open,don't open by program but by SSMS select source and target the launch data compare it seems to create the project from there OK.
  
  This caused a few hours of frustration.

  icecurtain January 23, 2014 10:53

  - 0 +
• 
  Thank you for your comment Brian Donahue » Mon Aug 08, 2011 11:26 am. This solved my issue.
  SQL Data Compare 10.7.0.23 Standard Edition

  dei401 February 25, 2015 12:39

  - 0 +

Add comment

Please sign in to leave a comment.