Note : Download SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo) by Microsoft
SQL Server Modeling (formerly code name “Oslo”) is a set of future technologies that provide significant productivity gains across the lifecycle of .NET applications by enabling developers, architects, and IT professionals to work together more effectively with SQL Server at the center of the application lifecycle.
The components of the SQL Server Modeling CTP are:
- “M” is a highly productive, developer friendly, textual language for defining schemas, queries, values, functions and DSLs for SQL Server databases
- “Quadrant” is a customizable tool for interacting with large datasets stored in SQL Server databases
- SQL Server Modeling Services (formerly the “Oslo” Repository) is a SQL Server role for the secure sharing of models between applications and systems
Download SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo)
Abstract courtesy : Microsoft
What Happened to the SQL Server Modeling CTP
If you are reading this today, here is the short story. Oslo was an ambitious idea from Microsoft, and it stayed a preview. As far as I know, it never shipped as a final product, and the CTP releases stopped. So please treat this post as history, not as a download to try.
That does not mean the idea was wrong. Describing your schema in text and letting a tool build the database is common today. You see it in SQL Server Data Tools database projects, where the whole schema lives as scripts in source control, and in Entity Framework migrations for .NET developers.
There is also a lesson here about previews in general:
- A CTP is for learning and giving feedback, not for production.
- Keep anything you build on a preview small and easy to throw away.
- Watch for the final release, or the lack of one, before you plan a project around it.
I still like looking back at posts like this one. They remind me how many tools come and go, while plain T-SQL, good design and backups stay useful year after year. Every few years something promises to replace T-SQL, and so far it is still here.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
