azuredatastudio
azuredatastudio copied to clipboard
DoNotAlterChangeDataCaptureObjects = True is not working
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 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% |