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

Marco_S · January 17, 2019 8:58PM

Is it possible to just deploy static data but not schema changes? There is a switch -IgnoreStaticData for data, but is there also something like -IgnoreSchema which does the opposite and just deploy data?

Tianjiao_Li · January 21, 2019 9:46AM

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.

Marco_S · January 28, 2019 9:25PM

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).

chris_godfree · January 29, 2019 11:40AM

Commit the static data changes you want to deploy separately from any schema changes?

Marco_S · January 29, 2019 12:31PM

Yes, exactly

Tianjiao_Li · January 31, 2019 11:46AM

@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).

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk