I know I /can/ download SQLExpress, but I don't want it. I shouldn't /need/ it.
8 Answers, 1 is accepted
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.
the Telerik team
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)
So how about giving us a one-off copy of the databases here so I can run the demos of the Q3 Beta?
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.
the Telerik team
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?
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).