Possibilities with SQL Data Compare

• 
  Yes, this is possible. The command line syntax and some examples can be found here - https://documentation.red-gate.com/sdc13/using-the-command-line
  
  You could use the /Include switch to restrict the comparison to specific tables.

  Rob C January 10, 2019 13:24

  - 0 +
• 
  Thanks for the reply, I have looked at the mentioned documentation, but I still have my doubts if it would be possible to compare Table A in DB A with Table B in Database B or do I have to rename table B in Database B to the name table A before I can run the batch?. 
  

  Laa January 10, 2019 15:17

  - 0 +
• 
  You can compare tables with different names, but you would need to create a project file that mapped them. You would then use the project file to perform the command line comparison.
  
  Here's some more info on mappings - https://documentation.red-gate.com/sc13/setting-up-the-comparison/mapping-tables-and-columns

  Rob C January 10, 2019 15:55

  - 0 +
• 
  Ok So I now I found out how to map two tables with different names and save this in a project. The question left is then if it is possible to do the compare command line based with two tables that changes names. So today the table is called TableA_20190111 and TableB_20190111 but the new tables created tomorrow that needs to be compared would be called TableA_20190112 and TableB_20190112. Is this to dynamic to be handled command line based?
  

  Laa January 11, 2019 07:46

  - 0 +
• 
  You can't do it directly from the command line, but the project file is xml so you could replace the table name in the file and then run the comparison.

  Rob C January 11, 2019 10:32

  - 0 +
• 
  There isn't a supported way to do this, but the project file is in an XML format and you could probably craft one with the correct mappings information without too much trouble.

  sam.blackburn January 11, 2019 13:30

  - 0 +

Add comment

Please sign in to leave a comment.