export from secondary replica with READ_CAPTURE_SECONDARY query store state results in unusable bacpac
- 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
**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
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