Dropping tables without Migration Scripts

VSinha · July 7, 2017 1:12PM

Can we drop tables without adding Migration script because if we drop tables without migration script and continue anyway, Team City deployment fails? How to resolve this issue to get it successfully deployed through Team City without adding migration script to drop tables? Do we need to change any of Team City configuration settings?

Mark J · July 10, 2017 10:06AM

It sounds like you're using DLMA and the deployment process is quitting early because of the data loss warnings that are being output. I think you should be able to prevent that from happening by specifying the -AbortOnWarningLevel or -Force options documented in https://documentation.red-gate.com/display/DLMA2/Sync-DlmDatabaseSchema

Dropping tables without Migration Scripts

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk