TrimTrailingSpaces

• 
  You might want to try:
  
  mappings.Options = new EngineDataCompareOptions(
  MappingOptions.Default,
  ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default,
  SqlOptions.Default);
  
  - James
  --
  James Moore
  Red Gate Software Ltd

  James Moore June 20, 2006 05:55

  - 0 +
• 
  Thanks for the help, but it didn't work. It's acting like it is not accepting the setting... Do I need to set these options earlier in the process?
  
  Has anyone else been able to get this to work?

  shaynes41 June 20, 2006 12:20

  - 0 +
• 
  Hi there
  You may want to also configure the comparision session too. Here is a code snippit. (This code snippit also configures the SQL provider aswell.)
  

  ..... some stuff....
  			mappings.CreateMappings(db1.Tables, db2.Tables);
      
  			mappings.Options = new EngineDataCompareOptions( 
  				MappingOptions.Default, 
  				ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default, 
  				SqlOptions.Default); 
  
  			using (ComparisonSession session=new ComparisonSession())
  			{
  				session.Options = mappings.Options;
  				session.CompareDatabases(db1, db2, mappings);
  
  				m_TableDifferences = session.TableDifferences;
      
  				// now get the ExecutionBlock containing the SQL
  				// we want to run this on WidgetLive so we pass on true as the second parameter
  				SqlProvider provider=new SqlProvider();            
  				provider.Options = session.Options;
  

  Hope this helps.
  David

  david connell June 20, 2006 12:52

  - 0 +
• 
  That did the trick!
  
  Thanks!

  shaynes41 June 20, 2006 13:21

  - 0 +

Add comment

Please sign in to leave a comment.