Author: Pradeep Srikakolapu - Senior Product Manager
We’ve been listening, we’ve been building, now we’re sharing that SSMS 22.5 adds new capabilities to the Microsoft Fabric Warehouse experience. With this release, you can now manage warehouses directly from SSMS, create database projects from your warehouse connection, and benefit from improved connectivity with simplified permissions.
Full warehouse management right from SSMS
You can now create, rename, and delete Fabric Warehouses directly from SQL Server Management Studio, without switching to the Fabric portal. Whether you’re creating a warehouse for proof of concept or cleaning up after a migration, these actions are available within SSMS.
Figure: Create, rename or delete your fabric warehouses from SSMS 22.5.
Create SQL database projects directly from SSMS 22.5
You can now create a database project directly from your Fabric Warehouse connection in SSMS. This enables a more streamlined workflow from exploring your warehouse to building version-controlled, deployable database projects within the same tool.
This is a major management and development upgrade, and it opens workflows that were previously way more friction than they needed to be.
Figure: Build your warehouse using sql database projects in SSMS 22.5.
Bug fix: No workspace permissions required to connect
Previously, connecting to a Fabric Warehouse in SSMS required workspace-level permissions — even when it shouldn’t have. This has been updated so that only item-level permissions are required to connect.
What’s on the roadmap
- Create database project from warehouse connection — Go from a live warehouse connection to a version-controlled database project in just a few clicks. Streamlines the path from exploration to CI/CD-ready development.
- Gov cloud support — Fabric Warehouse connectivity in SSMS for government cloud environments, bringing the same management and development experience to regulated workloads.
- Script generation for tables, views, and more — Right-click and generate CREATE scripts for your warehouse objects. Essential for documentation, migration, and sharing schema definitions across teams.
Enable/Disable schema grouping — Control how objects are organized in Object Explorer. Toggle schema grouping on or off to match the way you prefer to browse and navigate your warehouse.
Conclusion
SSMS 22.5 makes Fabric Warehouse administration and development feel native in one place: manage warehouses directly in Object Explorer, create SQL database projects from live connections, and connect with the right item-level permissions — without extra workspace access.