microsoft / microsoft/DacFx

export from secondary replica with READ_CAPTURE_SECONDARY query store state results in unusable bacpac

Open
#695 2 comments 0 reactions 0 assignees View on GitHub
bug sql-feature
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

SqlPackage or DacFx Version: sqlpackage-win-x64-zh-Hant-170.0.94.3
.NET Framework (Windows-only) or .NET Core: .NET8.0
Environment (local platform and source/target platforms): Windows server 2022 and Azure Sql

Image

**Steps to Reproduce:**

1. export sql with /SourceConnectionString ApplicationIntent=ReadOnly
2. import with create new database
3. pop error "The option 4 for querystore operation_mode is not supported."

**Did this occur in prior versions? If not - which version(s) did it work in?**

(DacFx/SqlPackage/SSMS/Azure Data Studio)

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the export with /SourceConnectionString ApplicationIntent=ReadOnly, then import the resulting bacpac into a new database and trace handling of query store operation_mode 4. Done means the exported bacpac imports successfully without the unsupported operation_mode error; the issue names no files or tests to begin with.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, csharp, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.