A couple weeks ago my good friend and MVP, Robin Shahan (RobinDotNet), wrote up instructions on how to get a bootstrapper package for SQL Server Express 2008 R2 that you can use with ClickOnce deployments. Visual Studio 2010 comes with the bootstrapper for SQL Server Express 2008 but not R2. Robin’s post will show you how to create one:
Read it on her blog: How about a bootstrapper package for SQLServer Express 2008 R2?
Thanks Robin! Enjoy!