Comparing tables with different names

• 
  Have you seen this help topic?
  
  http://www.red-gate.com/supportcenter/C ... c43727.htm
  
  You can get there by pressing F1 on the mapping tab.

  simon.jackson February 23, 2009 10:34

  - 0 +
• 
  Thanks for the link. In your example, when you remap a table both source and destination tables have the same name "WidgetPrices". I would like to copy data from "WidgetPrices" into say "WidgetPricesNew" and I can't see how the "Map" diakog allows me to to do that

  laurieb February 23, 2009 10:44

  - 0 +
• 
  Try
  - Make sure both tables are unmapped (select them in the top pane and click unmap)
  - Select WidgetPrices on the left of the bottom pane
  - Select WidgetPricesNew on the right of the bottom pane
  - Click map.
  
  Hope that helps.

  simon.jackson February 23, 2009 11:16

  - 0 +
• 
  Simon
  
  Thanks for that. I've managed to do it where the two tables are in the same database. A suggestion that the user interface could be a bit more explicit in future versions.

  laurieb February 23, 2009 11:33

  - 0 +

Add comment

Please sign in to leave a comment.