You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
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
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
The text was updated successfully, but these errors were encountered: