Microsoft SQL server module in alpha

Posted by Sigurd Magnusson on 22 April 2009

SilverStripe can now run entirely off a Microsoft SQL Server 2008 database!

Microsoft SQL Server 2008 logo

This allows SilverStripe to easily connect to existing databases and fit into environments where you don't necessary want MySQL. It allows SilverStripe to be used in as many situations as possible, in much the same way as supporting multiple web browsers and operating systems does.

SQL Server Support is provided by installing the SQL Server Database module, currently in alpha. This module works only with our daily builds currently, and is little more than one powerful PHP file and is quite easy to install. The current state of the code lets you carry out the tasks you would expect: install SilverStripe; add fields through invoking /dev/build; use the CMS; and, to the best of our knowledge, run all our modules.

The main known limitation currently relates to automatic column type changes. If you create a field (for example 'TShirtSize') as numeric field and then decide you need to change it to a text field, you would normally change the type in PHP and run /dev/build to update the database. In MySQL this would adapt the field and preserve the data as much as the new column allows. However, such a feature is less easy to implement in SQL Server so you currently need to perform schema changes manually. This issue also applies to changing field precision, for example changing VARCHAR(10) to VARCHAR(40).

Other than that, we're using the code with success internally, and know others in the community are too. We're mentioning this SQL Server milestone in the blog to let you know that the feature is well on its way, and to allow careful developers a chance to try it out, provide feedback, and files bugs before we mark it as a publicly stable module.

Organisations wishing to make use of it in production today can contact us for commercial support, or wait some months for this to be part of our standard release.

Something you might not know is that Microsoft has long provided SQL Server 2008 Express, a free version of SQL Server. The only limitation of the express edition is that it will only utilise up to 1 physical processor, 1 GB memory, and 4 GB storage on a machine, so it won't scale well beyond trial, development, or low-end production environments.

The Microsoft SQL Server Management Studio, demonstrating SilverStripe running on SQL Server 2008:

Screenshot of MS SQL Database Schema

 

Post your comment

Note: Comments are moderated and won't show until they are approved

Comments

  • this is nice.

    Posted by pex, 2 years ago

  • I find myself coming to your blog more and more often to the point where my visits are almost daily now!

    Posted by Milf Soup, 3 years ago @MilfSoup

  • Hi there,Really nice job,There are many people searching about that now they will find enough sources by your tips,Also looking forward for more tips about that

    Posted by Generic Cialis, 3 years ago @mattpowell

  • I think it's time to think about a captcha in your blog... (dont read the 3 pages of comments, it's all spam)

    Posted by Jean, 5 years ago

  • This allows SilverStripe to easily connect to existing databases and fit into environments where you don’t necessary want MySQL. It allows SilverStripe to be used in as many situations as possible, in much the same way as supporting multiple web browsers and operating systems does.

    Posted by payday loans in canada, 5 years ago

  • After the developing the OpenApplication which is the OpenOffice.org, Microsoft has new innovation software. Windows Vista was already released and now they are developing these <a rev="Vote for" title="Windows 7 launched! Vultures looking for easy pickings!" href="http://personalmoneystore.com/moneyblog/2009/05/12/windows-7-launched-vultures-easy-pickings/">Windows 7</a> as the newer version software that has a unique features compare to the released and develop software.

    Posted by Edwin_Y, 5 years ago

  • This is a great move. I am from an ASP.net background and i have used MSSQL in the past (until last month when i started using silverstipe for gor everything). Hopefully the adoption rate of Silverstripe in the enterprise will increase further due to MSSQL support.

    Thanks for the AWESOME CMS. :)

    Posted by L:amin Barrow, 5 years ago

RSS feed for comments on this page | RSS feed for all comments

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.