How is SQL Change Automation helping you? Share to win DevOps books.

Skip baseline error

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?
Tagged:

Answers

Sign In or Register to comment.