Is it possible to just deploy static data but not schema changes?

• 
  If you use SQL Change Automation, this should be possible. You may find this page helpful.
  
  If not, you should use SQL Data Compare to sync the target database with source.

  Tianjiao_Li January 21, 2019 09:46

  - 0 +
• 
  Thanks for your comment. I know how to include static data on deployment, but it's always bound to schema changes as well (if any). I was asking if it's possible to just deploy data without schema changes (using SQL Change Automation over Azure DevOps).
  

  Marco_S January 28, 2019 21:25

  - 0 +
• 
  Commit the static data changes you want to deploy separately from any schema changes?
  

  chris_godfree January 29, 2019 11:40

  - 0 +
• 
  Yes, exactly
  

  Marco_S January 29, 2019 12:31

  - 0 +
• 
  @Marco_S
  
  Unfortunately there isn't IgnoreSchema parameter and as I mentioned before, you can use SQL Data Compare to only deploy Static Data.
  
  It might be worth noting that SDC command line is always installed alongside SCA powershell, so you can use that (it will be on a subfolder named SDC).

  Tianjiao_Li January 31, 2019 11:46

  - 0 +

Add comment

Please sign in to leave a comment.