--- title: "Cloud-Native Data Without Starting Over" url: https://daily.dev/posts/cloud-native-data-without-starting-over-fzkyivvuh source_url: https://www.youtube.com/watch?v=kk9sqCTQBd0 type: video:youtube source: "We Are .NET" published: 2026-06-16T21:31:03.117Z updated: 2026-06-16T21:31:25.608Z tags: ["mcp", "microsoft-sql-server", "vector-search"] reading_time: 30 upvotes: 0 comments: 0 language: 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. # Cloud-Native Data Without Starting Over **[We Are .NET](https://daily.dev/sources/wearedotnet)** · 30 min read · 0 upvotes · 0 comments ## Summary A step-by-step walkthrough for modernizing a SQL Server-based application without a full rewrite. Covers five incremental stages: migrating from System.Data.SqlClient to Microsoft.Data.SqlClient, upgrading to SQL Server 2025 (with its new vector data type and binary JSON), replacing CRUD APIs with Data API Builder (REST, GraphQL, and MCP endpoints), managing schema via SQL database projects in CI/CD, and enabling AI agents to securely query data through SQL MCP server. Live demos show full-text/BM25 search replaced by vector semantic search, hybrid multi-database routing through a single API surface, and GitHub Copilot using the MCP endpoint to query products. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#mcp](https://daily.dev/tags/mcp), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server), [#vector-search](https://daily.dev/tags/vector-search) [View this post on daily.dev](https://daily.dev/posts/cloud-native-data-without-starting-over-fzkyivvuh)