Silverlight RIA samples with SQL 2005

I have recently been looking at RIA with Silverlight 4 and Visual Studio 2010.

Brad Abrams has some great posts on all of this and also touched on a subject that I will be looking into a little more - RIA DomainService with NHibernate.

One thing I found is that the the examples use a modified Northwind database with the SuperEmployee table - this comes with the samples but it is a SQL 2008 database.  I needed to have this run off SQL 2005 as my target platform has 2005 and I wanted to be sure all is going to be OK when we put it out there (and one development machine does not yet have SQL 2008 installed on it).

As there is no 'downgrade' for the database to attach it is SQL 2005 I decided to find use an instance of SQL 2008, attached the MDF supplied with the code for one of Brads posts and then use the SQL Database Publishing Wizard (build into Visual Studio 2008) to script the database and target that script for SQL Server 2005.

To get the SQL Server 2005 database setup follow these steps:

1. Create a new empty database (I called mine SuperNorthwind)

2. Execute the SQL script found here against your new database


You will of course needs to tweak your connection strings accordingly but should be good to go with 2005 for the RIA samples now.