customize this code

Comments

• alexstyler Posts: 22

  July 10, 2007 12:15PM

  Bringing my reply over from your topic on the version 6 forum...

  This you would have to do using your own code to parse apart your config file.
  
  Instead of mappings.CreateMappings(db1.Tables, db2.Tables), you would code to add each TableMapping to the TableMappings individually.
  
  That is:

  TableMappings mappings = new TableMappings();
  mappings.Join(db1.Tables["[dbo].[myTable]"], db2.Tables["[dbo].[myTable]"]);
  
  using(ComparisonSession session = new ComparisonSession()){
  session.CompareDatabases(db1, db2, mappings);
  }
  

  
  Thats just an example of how to add one Table to Table mapping. When you do it individually like that, you can map Views to Views or even Tables to Views. You should parse your list of tables into a list of strings, and iterate through it, joining each individually using mappings.Join(...).
  
  Note the format of a table name, it is fully qualified, specifying both the schema(owner) and table name like: "[dbo].[myTable]"
  
  Once again, I don't work for Red Gate, but I've become pretty familiar with the toolkit.
  ...

  0 · Share on Twitter