Suggestion: Map objects

• 
  This is something we've been hoping to do for a while, but unfortunately it keeps missing the cut. Could you describe the use case in which this would be useful to you?
  
  David Atkinson
  Product Manager
  Red Gate Software

  David Atkinson February 21, 2011 09:18

  - 0 +
• 
  I ave an application that has a configuration database (menu items, settings, etc.)
  
  In my development machine my database has a differente schema from the QA (and production) database.
  
  The MyTable in QA is the MyTable view on my machine that joins data from MyTableQA (replica of QA's MyTable) and MyTableLocal (local overrides).
  
  This way, I can keep all APIs (SPs, services, etc.) in sync with QA.
  
  Everytime I need to use my local database, I only have to sync with QA, which SQL Data Compares does nicelly.

  paulo_morgado February 21, 2011 19:41

  - 0 +
• 
  A workaround would be to compare two views that you create specifically for the comparison. These just need to select from the appropriate tables. As the views would belong to the same schema and have the same name, SQL Compare will map them.
  
  Would this work for you?
  
  David

  David Atkinson February 22, 2011 04:29

  - 0 +
• 
  No, because I don't want to compare data - SQL Data Compare does a very good job at that.
  
  I want to compare "equal" tables that just happen to have different names.
  
  Can I map Schema1 in one database to both Schema1 and Schema2 in another? I could live with tables with the same name in another schema.

  paulo_morgado February 22, 2011 04:46

  - 0 +
• 
  Good question. It might work. Please try to map the schemas using the Owner Mapping tab in the Project Configuration dialog and let us know if this doesn't work for you.
  
  David

  David Atkinson February 22, 2011 04:53

  - 0 +
• 
  Nope. I would need to map more than one schem on my local database to the same schema on the QA database.

  paulo_morgado February 22, 2011 11:36

  - 0 +
• 

  David Atkinson wrote:

  This is something we've been hoping to do for a while, but unfortunately it keeps missing the cut. Could you describe the use case in which this would be useful to you?

  
  David,
  
  I think what I describe here might be a valid use case for this functionality:
  
  http://www.red-gate.com/MessageBoard/vi ... hp?t=14063
  
  Thanks

  wibblemonkey September 29, 2011 09:29

  - 0 +
• 
  The SQL Compare 9.5 Beta now has table and column mapping. More information here:
  
  http://www.red-gate.com/MessageBoard/vi ... hp?t=14113
  
  David

  David Atkinson November 03, 2011 06:38

  - 0 +

Add comment

Please sign in to leave a comment.