I have installed on my computer the Enterprise edition of SQL 2008 Server and while working on the TRY IT OUT of Chapter 12: On double-clicking the .mdf sql server database file in my VS2010 solution explorer, I got a "required component missing report alert" demanding for either SQL 2005 or SQL 2008 Express edition to be installed and running.
My question is : can't I migrate/export the above database file to my installed Enterprise edition and then use it for this try it out exercise? If this is possible, how do I go about it, please?
Regards.

Hi there,

Yes, you can. You can attach the MDF file to SQL Server and then modify the connection string so it points to your database. Chapter 19 and Appendix B have more information.

However, if I were you I would also install SQL Server Express. It's free and can be run side by side with your version of SQL Server. Many code examples, books and even tools (VWD 2010 for example) assume the presence of SQL Express.

Cheers.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks Imar!
My VS2010 came with an Express edition but I felt it was superfluous to my requirement when I intalled my SQL Server Enterprise so I had it removed.
Based on your counsel, I'll re-install and provide feedback.
Thanks, once more.