Skip baseline error

VKh

Hi ,

I created a baseline from an existing database in PROD with dev database as my working DB. My deployment to dev worked. Now, when i deploy to QA database (which also has all of DEV & PROD object) my deployment fails with below error. 

System.Management.Automation.CmdletInvocationException: An unhandled error occurred: RedGate.Versioning.Engine.Api.Exceptions.VersioningEngineConfigurationException: The existing database [XXX] needs to be baselined prior to deployment (a baseline is required to ensure that existing database objects are not affected during an initial SQL Change Automation project deployment). See the following article for more information: https://www.red-gate.com/sca/dev/baseline. Alternatively, you can attempt to deploy without a baseline by <SkipBaselineCheck>True</SkipBaselineCheck> to your .sqlproj file.

I created baseline from PROD, but why doesn't it allow me to deploy to QA?

Sergio R

Hi,

It looks like for some reason, the baseline is not set correctly.

Can you check if in your project settings you have a tick in the "Mark first folder as baseline" check box?



Kind regards,

VKh

I don't see that checkbox at my IDE.

VKh

Btw, am using VS2019 for Azure SQL.

Sergio R

That option will be below the Migration Grouping option that appears on your screenshot, you will have to scroll down using the scroll bar on the right: