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

Marco_S

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

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

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

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

Marco_S

Yes, exactly

Tianjiao_Li

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