Synchronize schema only

• 
  SQL Compare can (and does) synchronize the schema. Data Compare is for synchronizing data, although it does seem to have some limited schema synchronization in later versions, just for the purpose of making it easier to copy the data.
  
  Hopefully this helps.

  Brian Donahue June 30, 2014 07:30

  - 0 +
• 
  Excellent, thank you very much.
  
  I have a follow up question, though:
  
  In SQL Compare, I have about 10 tables that are only in the source DB. I select about 5 of those, and deploy. All good.
  
  Then if I save the SCP project and execute it, ALL tables get copied over.
  
  This is my command line:
  "C:\Program Files (x86)\Red Gate\SQL Compare 10\sqlcompare" /project:QA_to_Prod.scp /Synchronize
  
  How do I sync just the tables selected in the project ?
  
  Thank you,
  Simon

  SimonMazzucca June 30, 2014 15:32

  - 0 +
• 
  The "Include dependencies" option may be the cause of that.

  Brian Donahue July 03, 2014 04:39

  - 0 +

Add comment

Please sign in to leave a comment.