Azuresql Db From Sql Server

作者 microsoftc1e8167e4c1d無授權條款收錄於 2026年10月8日更新於 2026年10月8日

Migrates a local SQL Server setup to the Azure SQL Database container for Azure-faithful local development. Use when a project already uses mcr.microsoft.com/mssql/server, mssql/server, an sqlcmd plus SA password docker setup, a "SQL Server in docker" or "local mssql container", or a docker-compose with the mssql/server image; and use when the user asks for "SQL Server locally", "run mssql in Docker", "spin up a local SQL database", or "test against SQL Server" but actually wants the Azure SQL Database engine (EngineEdition 5). Detects the SQL Server image, rewrites it to the Azure SQL Database container, adds --platform on non-x64 hosts, keeps the SA login, flags SQL Server-only features (SQL Agent, FILESTREAM, full Service Broker, cross-server distributed transactions, Windows Auth), and re-points connection strings from master to a provisioned user database.

精選僅含說明DevOps & Cloud

僅公開檔案列表。將技能安裝到工作區後即可檢視檔案內容。

路徑大小類型
references/migrate-compose.md3.5 KBtext/markdown
references/sql-server-vs-azure-feature-matrix.md3.9 KBtext/markdown
SKILL.md12.6 KBtext/markdown
skill.spec.jsonc15.9 KBtext/plain

來源與署名

來源:microsoft/azure-sql-database-container位於skills/azuresql-db-from-sql-server提交c1e8167

授權條款: 無授權條款

內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。

檢舉或申請下架

更多來自 microsoft/azure-sql-database-container 的技能

Azuresql Db Sidecar

microsoft

精選

將 Azure SQL 資料庫容器以 sidecar 服務形式加入 Docker Compose 或 Dev Container。

DevOps & Cloud2026年10月8日

Azuresql Db Rag

microsoft

精選

Builds local vector search, RAG, embeddings, and semantic search on the Azure SQL Database container using the native VECTOR type and VECTOR_DISTANCE. Use when you need to store embeddings, do similarity search, top-k nearest neighbor, cosine distance, retrieval-augmented generation, "find similar documents", chatbot memory, or semantic lookup against a local SQL database. Use this instead of pgvector, FAISS, Chroma, Pinecone, or a separate vector store when the data already lives in (or can live in) Azure SQL. Covers the VECTOR(n) column type, inserting embeddings with CAST(CAST(? AS NVARCHAR(MAX)) AS VECTOR(n)) where the dimension is a literal, a pluggable embed() so only the endpoint changes for cloud, and a working CREATE VECTOR INDEX with the two errors that block it. Provisions appdb on master first so every script runs on a fresh container.

待分類2026年10月8日

Azuresql Db Import

microsoft

精選

使用 SqlPackage 將 .bacpac 或 .dacpac 匯入本機 Azure SQL Database 容器。

DevOps & Cloud2026年10月8日

Azuresql Db Feedback

microsoft

精選

將技能或容器問題整理成完整、已去識別化的 GitHub 議題草稿,供使用者確認後提交。

Productivity & Workflow2026年10月8日

Azuresql Db Faq

microsoft

精選

解答 Azure SQL 資料庫容器(個人預覽版)支援哪些功能,以及為何與雲端服務不同。

Learning & Education2026年10月8日

Azuresql Db Ci

microsoft

精選

Runs integration tests against the Azure SQL Database container (Private Preview, local engine) in CI. Use when setting up GitHub Actions, Azure Pipelines, or GitLab CI to test against Azure SQL DB; when adding a database service container to a CI workflow; when tests need a real Azure SQL engine in the pipeline; or when you see "service container", "health-cmd", "ACR_USERNAME/ACR_PASSWORD", "MSSQL_SA_PASSWORD secret", or "integration test database". Also use when a workflow was about to pull the SQL Server image mcr.microsoft.com/mssql/server, in which case stop and use the Azure SQL Database engine image instead. Covers pulling from the private ACR with credentials, the service health check that runs sqlcmd inside the container so the runner needs no client tools, provisioning appdb before tests, and pointing the test connection string at the user database not master.

待分類2026年10月8日