Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DoNotAlterChangeDataCaptureObjects = True is not working #25612

Open
arkdvd opened this issue Apr 26, 2024 · 0 comments
Open

DoNotAlterChangeDataCaptureObjects = True is not working #25612

arkdvd opened this issue Apr 26, 2024 · 0 comments

Comments

@arkdvd
Copy link

arkdvd commented Apr 26, 2024

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 (4970733, 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%
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant