--- title: SQL Meets Fabric: Migrate, Mirror, Build | daily.dev description: Microsoft's SQL database in Fabric is a serverless database built on the same SQL engine as SQL Server 2025 and Azure SQL. It automatically mirrors data to... canonical: https://daily.dev/posts/sql-meets-fabric-migrate-mirror-build-fstkk0v7p twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: SQL Meets Fabric: Migrate, Mirror, Build | daily.dev og:description: Microsoft's SQL database in Fabric is a serverless database built on the same SQL engine as SQL Server 2025 and Azure SQL. It automatically mirrors data to... og:url: https://daily.dev/posts/sql-meets-fabric-migrate-mirror-build-fstkk0v7p og:image: https://api.daily.dev/og/posts/FsTKK0V7P.png og:image:alt: SQL Meets Fabric: Migrate, Mirror, Build og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # SQL Meets Fabric: Migrate, Mirror, Build **[Microsoft Developer](https://daily.dev/sources/microsoftdeveloper)** · 36 min read · 0 upvotes · 0 comments ## Summary Microsoft's SQL database in Fabric is a serverless database built on the same SQL engine as SQL Server 2025 and Azure SQL. It automatically mirrors data to OneLake in near real time with no ETL pipelines needed. A demo shows creating a database in under 3 minutes, roughly 30 to 40 seconds for provisioning plus a few minutes to load sample data. The product also includes a migration tool for moving existing databases using a DAC pack, GitHub and Azure DevOps source control integration, and native vector data type support for building RAG applications directly in T-SQL using functions like AI_generate embeddings and vector distance, connecting to Azure OpenAI models. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I build a RAG application using SQL Server data without external pipelines? SQL database in Fabric lets you build RAG applications directly in T-SQL. You create an external model pointing to an Azure OpenAI embeddings endpoint, use the AI_generate embeddings function to store vectors in a table column, then run a vector distance function for similarity search, and pass the retrieved context plus the user's question to a GPT-4.0 endpoint via sp_invoke_external_rest_endpoint, all without middleware. _Developers wiring RAG into SQL workflows can track engine updates like this on daily.dev._ ### How does automatic data mirroring work in Microsoft Fabric's SQL database? Data in a Fabric SQL database is automatically replicated to OneLake in near real time with zero configuration, starting as soon as the database is provisioned. The replicated data lands in open-source Delta format, making it accessible to every Fabric workload, and a SQL analytics endpoint lets you query it across the platform without copying it or building ETL pipelines. _Teams weighing managed mirroring against custom ETL can follow database architecture news on daily.dev._ ### How long does it take to create a new SQL database in Microsoft Fabric? Creating a new SQL database in Fabric takes about 30 to 40 seconds for provisioning, with a few additional minutes needed to upload sample data, putting the whole process at under 3 minutes end to end. Provisioning happens directly from the Fabric web interface with no server configuration required, just naming the database. _Developers evaluating fast-provisioning database options can keep up with releases like this on daily.dev._ ## Similar posts on daily.dev - [New T-SQL AI Features are now in Public Preview for Azure SQL and SQL database in Microsoft Fabric](https://daily.dev/posts/new-t-sql-ai-features-are-now-in-public-preview-for-azure-sql-and-sql-database-in-microsoft-fabric-x0vb8r1z1) · DevBlogs · 0 upvotes · 0 comments --- Tags: [#azure](https://daily.dev/tags/azure), [#sql](https://daily.dev/tags/sql), [#rag](https://daily.dev/tags/rag), [#vector-search](https://daily.dev/tags/vector-search), [#microsoft-fabric](https://daily.dev/tags/microsoft-fabric) [View this post on daily.dev](https://daily.dev/posts/sql-meets-fabric-migrate-mirror-build-fstkk0v7p) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"SQL Meets Fabric: Migrate, Mirror, Build","url":"https://daily.dev/posts/sql-meets-fabric-migrate-mirror-build-fstkk0v7p","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/sql-meets-fabric-migrate-mirror-build-fstkk0v7p"},"datePublished":"2026-10-20T21:25:09.098Z","dateModified":"2026-10-20T21:25:38.312Z","description":"Microsoft's SQL database in Fabric is a serverless database built on the same SQL engine as SQL Server 2025 and Azure SQL. It automatically mirrors data to...","image":"https://i.ytimg.com/vi/JLVHKSYf5Pw/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/JLVHKSYf5Pw/sddefault.jpg","isAccessibleForFree":true,"articleSection":"Microsoft Developer","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Microsoft Developer","logo":"https://media.daily.dev/image/upload/s--xZzU3zUq--/f_auto/v1746714872/logos/microsoftdeveloper","url":"https://daily.dev/sources/microsoftdeveloper"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/sql-meets-fabric-migrate-mirror-build-fstkk0v7p","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"azure,sql,rag,vector-search,microsoft-fabric","timeRequired":"PT36M","video":{"@type":"VideoObject","name":"SQL Meets Fabric: Migrate, Mirror, Build","description":"Microsoft's SQL database in Fabric is a serverless database built on the same SQL engine as SQL Server 2025 and Azure SQL. It automatically mirrors data to...","thumbnailUrl":"https://i.ytimg.com/vi/JLVHKSYf5Pw/sddefault.jpg","uploadDate":"2026-10-20T21:25:09.098Z","duration":"PT36M","url":"https://api.daily.dev/r/FsTKK0V7P","embedUrl":"https://www.youtube.com/embed/JLVHKSYf5Pw"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Microsoft Developer","item":"https://daily.dev/sources/microsoftdeveloper"},{"@type":"ListItem","position":3,"name":"SQL Meets Fabric: Migrate, Mirror, Build"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/sql-meets-fabric-migrate-mirror-build-fstkk0v7p#faq","mainEntity":[{"@type":"Question","name":"How do I build a RAG application using SQL Server data without external pipelines?","acceptedAnswer":{"@type":"Answer","text":"SQL database in Fabric lets you build RAG applications directly in T-SQL. You create an external model pointing to an Azure OpenAI embeddings endpoint, use the AI_generate embeddings function to store vectors in a table column, then run a vector distance function for similarity search, and pass the retrieved context plus the user's question to a GPT-4.0 endpoint via sp_invoke_external_rest_endpoint, all without middleware. Developers wiring RAG into SQL workflows can track engine updates like this on daily.dev."}},{"@type":"Question","name":"How does automatic data mirroring work in Microsoft Fabric's SQL database?","acceptedAnswer":{"@type":"Answer","text":"Data in a Fabric SQL database is automatically replicated to OneLake in near real time with zero configuration, starting as soon as the database is provisioned. The replicated data lands in open-source Delta format, making it accessible to every Fabric workload, and a SQL analytics endpoint lets you query it across the platform without copying it or building ETL pipelines. Teams weighing managed mirroring against custom ETL can follow database architecture news on daily.dev."}},{"@type":"Question","name":"How long does it take to create a new SQL database in Microsoft Fabric?","acceptedAnswer":{"@type":"Answer","text":"Creating a new SQL database in Fabric takes about 30 to 40 seconds for provisioning, with a few additional minutes needed to upload sample data, putting the whole process at under 3 minutes end to end. Provisioning happens directly from the Fabric web interface with no server configuration required, just naming the database. Developers evaluating fast-provisioning database options can keep up with releases like this on daily.dev."}}]} ```