How to set "baseline your incremental migrations" in Project Settings.

GurpreetGill

Hi 

I have below scenario.

Having existing Production Database as well as Development Database.
Created SCA Project, by setting "Production Database" as Target Database and "Development Database" as "development Database"
Baseline script is created and marked as Deployed.
Checked the checkbox "Mark all Programmable Objects/additional scripts as deployed when setting the baseline"

Now when building project, getting below error.

##[warning] DbBuildTask: ERROR X:\xxxx\xxxx\xxxxxx.sqlproj(0,0): Baseline configuration error: If you opt to baseline your programmable objects,

##[warning] you must also baseline your incremental migrations. This can be configured within Project Settings.

How to set "baseline your incremental migrations" ?

Thanks
Gill

Russell D

Taking a look at https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-scripts-to-capture-database-changes/baselines should help you get started.