All geek questions in one place

Vsdbcmd data loss can occur, but where?

When using vsdbcmd to deploy my database:

vsdbcmd.exe /a:Deploy /manifest:MyDatabase.deploymanifest

I get:

SQL01268 .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 6 Rows were detected. The schema update is terminating because data loss might occur. SQL01268 An error occurred while the batch was being executed.

This is good, but it does not tell me where the dataloss will occur. To find out that I should use <DeployToScript>True</DeployToScript> , load the script up to see:

IF EXISTS (select top 1 1 from [dbo].[MyTable]) RAISERROR ('Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT

Is there any way to get vsdbcmd to display this information when deploying directly to the database without the need to generate sql in the first place?

thanks

+6
source share
2 answers

There is no way to do this, it is a mistake (or a missing function). See Tom's comment on my question.

0
source

For me, I needed to clear my DB before deploying SQL

-1
source

Source: https://habr.com/ru/post/887366/

More articles:


All Articles