Microsoft Dev Blogs

MSSQL Extension for VS Code: Schema Compare, Schema Designer, Local SQL Server Container GA

thumbnail

Table of Contents


Schema Compare (GA)

  • Compare schemas across databases or database projects and apply changes with confidence.
  • Effortlessly compare database schemas, pinpoint differences, and apply updates seamlessly between databases or files.
  • Enhanced option settings include include/exclude functionality and dropdown option styling for lighter themes.

Schema Designer (GA)

  • Interactive database diagramming experience in VS Code.
  • Fast loading, performance improvements, visual and usability enhancements.
  • Collapse/expand button for tables with many columns, foreign-key icons, tooltips for long names, and more.
  • Restored relationship-line visibility, support for self-referencing foreign keys, enhanced auto-arrange behavior for diagrams.

Local SQL Server Container (GA)

  • Provision local SQL Server containers directly from the extension without writing Docker commands.
  • Choice of running SQL Server 2025 (Public Preview) with enhanced features or other supported versions.
  • Custom settings for container name, hostname, and port via UI, progress indicator during image download, step-by-step Docker checks, and more.
  • Improved UX around port conflict handling to make setup more predictable and reliable.

Other updates

  • Improved Microsoft Entra ID sign-in experience, more responsive query results, new Text View mode, session-based SQL Auth, improved localization, and GitHub Copilot stability enhancements.