Hello Stuart,

We prefer to distribute SQLExpress versions of our online demos databases because it is free and does not set requirement for the developers to by the licensed SQL Server 2008 version. I suppose that you can configure and run the same SQLExpress databases on full-blown SQL 2008 Server without hitting any obstacles - let me know if I am leaving something obvious out.

Greetings,
Sebastian
the Telerik team

> We prefer to distribute SQLExpress versions of our online demos databases because it is free 
And very laudable to. However, we don;t all have access to it, especially in a work environment where its big brother is installed.

Distributing attachable copies of the DBs would cost you nothing to do, and you meet the needs of both groups.

> I suppose that you can configure and run the same SQLExpress databases on full-blown
> SQL 2008 Server without hitting any obstacles
Perhaps you'd explain how 'cos my every attempt to do so has failed. Attempting to attach the DB results in the following
Database '<path>. cannot be upgraded because it it read-only or has read-only files. Make the database of files writable and rerun the recovery (Microsoft SQL Server. Error 3415)

-- 
Stuart

OK

So how about giving us a one-off copy of the databases here so I can run the demos of the Q3 Beta?

-- 
Stuart

Hello Stuart,

I hope that the information from this MSDN thread will help you detach the SQLExpress databases and attach them to your SQL 2008 server instance.

Regards,
Sebastian
the Telerik team

OK this is an ancient thread but there are MDF files under AppData for the ASP.NET Ajax demos....  I am going to attach them to SQL Server 2012 and fix the connect strings etc.

That's an absolutely valid approach, Allen. We do try to keep the demos site self-contained (which is why it is a WebSite and not a WebApplication type of project). As with any code/project, it may not match every machine completely so some tweaks may be necessary according to the concrete setup.

Regards,
Marin Bratanov
Progress Telerik

Thank you Marin.  As I said I do not want to poke a sleeping dragon and wake up this ancient thread, but it would be extremely helpful to have a list of all the files I must check for connection strings that need to be reworked. It would suffice  for you to tell me it is all the files in the demo root folder. But are there any others?

I found multiple instances of the various SQL Express databases as well.  Presumably these are all copies of each other, without diff'ing them.  Again, does it suffice to fix the connect strings everywhere to point at the SQL Server database instances or are there other hidden dangers?

Thank you.

 

 

 

 

 

Hi Allen,

The ~/web.config file in the root holds the connection strings used by the demos. Modifying it will suffice.

The databases the demos use are in ~/App_Data so you can take them and attach them to the SqlServer you have. They should be the same in recent years, most of the databases have been the same for 4-5 years, Telerik.mdf has a few minor fixes in early 2016.

I am not aware of any dangers in using SqlServer instead of SqlExpress (assuming it is a version later than 2008, otherwise it won't read the databases).

Regards,
Marin Bratanov
Progress Telerik