vsdbcmd可能会发生数据丢失，但是在哪里呢？

发布于 2024-11-05 17:38:52 字数 563 浏览 0 评论 0原文

使用 vsdbcmd 部署数据库时：

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

我得到：

SQL01268 .Net SqlClient 数据提供程序：检测到消息 50000，级别 16，状态 127，第 6 行。由于可能会发生数据丢失，架构更新正在终止。 SQL01268 执行批处理时发生错误。

这很好，但它没有告诉我哪里会发生数据丢失。为了找出答案，我必须使用 True，然后加载脚本以查看：

IF EXISTS (select top 1 1 from [dbo].[我的桌子]) RAISERROR ('检测到行。架构更新正在终止，因为可能会发生数据丢失。', 16, 127)WITH NOWAIT

有没有办法让 vsdbcmd 在直接部署到数据库时显示此信息，而无需先生成sql？

谢谢

原文

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.

Which is fine, but it doesn't tell me where the dataloss will happen. In order to find out I have to use <DeployToScript>True</DeployToScript>, then 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 a way to get vsdbcmd to display this info when deploying direct to the DB without having to generate the sql first?

Thanks

分享到QQ

分享到微博