azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

DoNotAlterChangeDataCaptureObjects = True is not working

Open arkdvd opened this issue 1 year ago • 0 comments
trafficstars

Type: Bug

Hello, I tried to enable DoNotAlterChangeDataCaptureObjects = True IgnoreTableOptions = True DoNotAlterReplicatedObjects = True.

My publish errors out with message "Error: Verification of the deployment plan failed. Error SQL72035: [].[] is under change data capture control and cannot be modified.

Is this a Bug or am I not setting the right properties in publish ?

When I try enabling differently : DoNotAlterChangeDataCaptureObjects = False IgnoreTableOptions = False DoNotAlterReplicatedObjects = True.

In my generate scripts ( I see this coming up):

IF EXISTS (SELECT 1 FROM [sys].[databases] WHERE [name] = N'$(DatabaseName)') BEGIN ALTER DATABASE [$(DatabaseName)] SET QUERY_STORE = OFF WITH ROLLBACK IMMEDIATE; END

GO PRINT N'Altering Table [<userschema].[usertablename]...'; but no alter table statement found

Extension version: 1.4.2 Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 2024-02-27T00:05:08.293Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info
Item Value
CPUs 12th Gen Intel(R) Core(TM) i5-1250P (16 x 2112)
GPU Status 2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled
Load (avg) undefined
Memory (System) 15.67GB (1.67GB free)
Process Argv
Screen Reader no
VM 0%

arkdvd avatar Apr 26 '24 19:04 arkdvd