Wednesday, October 29, 2008

How to install Oslo with SQL Server Express Edition ?

As I was delving into the Visual Studio DSL Tools to design my first DSL for , I came across this new modeling platform by Microsoft : Oslo. In fact, it is so new that the first CTP has just been released.

Haven van OsloAs I already wrote on the blog of Salamanca, the vision for this new tool seems to be exactly what I had been needing :

It's actually taking the kind of models that you're seeing arising in specific domains, like software management in System Center, or your data design over in SQL, or your process activities over in BizTalk and saying, we need to take all these domains and be able to put them into one model space. In fact, we need to let people create their own domains that aren't just isolated, but that exist in this one modeling space. And that's what Oslo is about.

That's it. I just quoted Bill Gates !

So it was unavoidable that I tried to download and install the October 2008 CTP on my computer. Everything was OK, except for the fact that the installer could not create the repository on my SQL Server 2008 Express Edition database. The message was :

Create repository database failed, please try later

So I tried later, as suggested in the installed ReadMe file. Indeed, my SQL Server instance not being the default instance on my system, but rather being a named instance (the name being "SQLEXPRESS"), I understand why the repository creation failed. The trouble is that the command lines included in the file to manually create the repository are incorrect. So here are the correct ones :

CreateRepository.exe /db:.\SQLEXPRESS
mx.exe -i:Models.mx -db:Repository -s:.\SQLEXPRESS

Please note that the second command failed at first with the following message :

There is insufficient system memory in resource pool 'internal' to run this query.

But, as suggested on this Microsoft Connect SQL Server issue, letting the server "sit for a moment" solved the problem...