title: Is it possible to ignore NOT FOR REPLICATION in Visual Studio's Schema Compare?
body: <p>I have two environments: dev and test. Dev has a single SQL instance. Test has three which use merge replication.</p>
  
  <p>When I use Schema Compare between dev and test, every table is always flagged as different because the tables in Test have a few replication artifacts:</p>
  
  <ul>
  <li>A generated unique ID for replication: <code>[rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [MSmerge_df_rowguid_DDDF85B24558D414B8FD278B2219C33A]</code></li>
  <li>The primary key marked as <code>NOT FOR REPLICATION</code> (I see there is an option to ignore this in the General tab in Schema Compare Options)</li>
  <li>CONSTRAINT <code>[repl_identity_range...]</code> that requires the primary key be within the range assigned to that instance</li>
  </ul>
  
  <p>Is there a way to ignore the rowguid column  and the <code>repl_identity_range_...</code> constraint when running a schema compare?</p>